Forum Discussion
Opening a .mdb file
Check here for my EE article : https://www.experts-exchange.com/articles/33729/Importing-Tables-from-Older-Unsupported-Access-databases.html
- isladogsJun 06, 2022MVP
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
- EslamElbyalyJun 06, 2022Copper ContributorI tried it before, but as you can see, the data are not organized at all. Can not ACCESS files be opened in a text editor like that?
- George_HepworthJun 06, 2022Silver ContributorYou have the closest thing to an answer here. This is not a standard mdb file. We don't know what it is exactly. If you can retrieve the data, following Colin's suggestion of saving a copy as a .txt file, that's the closest you are probably going to get.
Please don't pursue this in both forums any longer as it's a waste of your time and ours to try to track it in two places.
I'm still not 100% convinced it is appropriate to try to extract data from a vendor's tool this way. They went to some trouble to obscure it by renaming it with the .mdb extension which probably suggests they don't anticipate their data being used outside their application. That said, you know what you can do now.
- isladogsJun 06, 2022MVP
Just as an experiment I used your utility to successfully extract all the data from the Access 1.0 version of the Northwind database
It took a bit of time but seemed to work perfectly.
Excellent. Very impressive
- tsgiannisJun 06, 2022Iron Contributor
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
https://web.archive.org/web/20060216154605/http://download.microsoft.com/download/c/d/c/cdc5d70c-25ab-42fb-974f-1514dc48ee30/Acc2Conv.exe
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.- isladogsJun 06, 2022MVPI remember using that many years ago.
Just tried to install it in Win 10 (using compatibility settings then in WinXP but both attempts failed