Jun 04 2022 06:36 PM
Jun 04 2022 06:36 PM
Hi. I havea .mdb file that I need to open. When I try to open it using MS access 2003 or 2007, I get "unrecognized database format.." error. I do not know what version was used to create that file. Is there a way to open it or extract data from it?
Jun 05 2022 12:27 AM
That means it was created in Access 97 or earlier. .. possibly all the way back to v1.0. To open it, you need to use an earlier version that supports that format then convert it to Access 2000 or later. This may need to be done in several steps depending on the version used originally.
As I have all Access versions, I may be able to assist. If interested, you can contact me via the contact form at the end of my Web article A Trip Down Memory Lane
Jun 05 2022 08:35 AM
Also asked on Microsoft Answers where the OP revealed in a follow up response that it is an mdb distributed with and for a third-party application. It may well be an older version, such as 97 or earlier. But given that provenance, I'm not willing to bet on much of anything without seeing it.
Jun 05 2022 07:29 PM
Jun 05 2022 10:35 PM
Jun 06 2022 12:56 AM
The email link in my article worked when I just tried it.
Anyway, I tried opening your file by several methods including Access v1.0 , Access 2.0, my own recovery software & the utility in the EE article by @tsgiannis.
All of those failed stating that the file was in an unrecognised format
Next I tried opening in a text editor and could read a lot of data from the file
However doing that also confirmed it isn't an Access MDB file
This is the start of the file in Notepad
Suggest you do the same using Notepad or a hex editor to recover whatever data is useful to you
Jun 06 2022 02:18 AM - edited Jun 06 2022 02:20 AM
Interesting...I think the oldest I had was '97 ...but 1.0... !!
For the author it seems that once upon a time was a converter that could convert Access from 2.0 and up to 2003
This tools is long long gone but thankfully Internet Archive (after a good search) still has it
Test it and report back If this fails I guess it's corrupt and you need to check some of the Access specialized people to restore it.
Jun 06 2022 04:06 AM
Jun 06 2022 04:08 AM - edited Jun 06 2022 04:25 AM
I believe modern versions of Excel have the same limitations as Access. Anything created before A2000 cannot be opened. Just tested with valid A95 & A97 files
However, if saved as a .txt file you can import it (tested successfully). My advice is:
1. Save a copy as a text file
2. Open in Excel and import as fixed width. Set suitable break points. You will then see much usable data (and lots of junk). For example, see attached screenshot
Jun 06 2022 05:03 AM
Jun 06 2022 05:04 AM
Jun 06 2022 05:15 AM - edited Jun 06 2022 05:16 AM
You cannot import from the MDB file as it is not a valid MDB database file
As already stated, saving a copy as a .txt file will allow you to import it into either Excel or Access using the fixed width option.
The data is organised but the usable data is split into several fields as it would have been initially (see my earlier screenshot)
There are almost 60 fields, most of which you can probably delete after inspecting them yourself
Jun 06 2022 06:43 AM