Cannot Open Access 2007 MDB file

I have an Access 2007 file that I was working on at my office.  I left for the day and the database was still open.  When I came back the next day the system had shut off so I rebooted (no issues).  I tried to open the database and am getting the error message:       "Unrecognized database format 'C:\....\filename.mdb"

I cannot get into the file, I cannot Compact/Repair it either.  Anyone have any suggestion on how to get the data "out"  I have tried using Access External Data, Creating an new DB and importing the broken file but I cannot get past the error message.  

I can open previous versions of the same database.

I really need to get the data.   I can attached the file if someone can figure out what to do with it??
jurictaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pcelbaCommented:
You may try 3rd party repair tool. E.g. http://www.repair-access-file.com/
A few more such tools exist.
0
jurictaAuthor Commented:
I had actually tried that specific program before and still got the error this is not a valid database.
0
pcelbaCommented:
The database can be overwritten by whatever... If the size is not big then you may look inside it by using e.g. Notepad but that's not a solution because you don't know the structure and to retrieve your data is difficult BUT you could see if some (text) data are available. (Hexadecimal editor is better than Notepad for this purpose.)

BUT if the repair tool does not recognize Access database then it could mean the damage is fatal  and the only way is to re-key the data into some older backup copy which is much easier than to mine your data from the damaged file byte after byte...

More expert way could be an attempt to fix the MDB file...
The MDB file structure is described e.g. here: http://xiph.org/positron/doc/mdb.html or here: http://www.e-tech.ca/001-AccessFileFormat.asp

Or... another repair tool: http://www.repairdocfile.com/how-to-repair-access-database-file.html
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Jeffrey CoachmanMIS LiasonCommented:
See this recent post...
...Try opening the mdb with OpenOffice
http://www.experts-exchange.com/Database/MS_Access/Q_28663928.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Before you do anything else, be sure you have a backup, and you're working on that backup. The more you try to fix a corrupt database, the less likely you'll be successful, so you should try all fixes on a copy of your database.

Given that you've already tried the automated solutions (which never seem to work, by the way), you might consider using www.everythingaccess.com. Wayne is very good at these sorts of things, and if your data is at all important to you it's worth the fee to recover.
0
jurictaAuthor Commented:
PCELBA got points (200) for suggesting a third party program but the actual full answer came from Jeffrey Coachman (300) who suggested OpenOffice (third party).  This program actually opened the database.  I was able to retrieve about 90% of the data.

Thanks to all who gave their expertise
0
Jeffrey CoachmanMIS LiasonCommented:
Yes, ...this was quite a revaluation to all Experts here.

It just goes to show that whenever you think you are having (creeping) corruption issues, you immediately make a backup of the DB as-is.

May people try to "fix" the actual database.
In some cases, the utilities to "Repair" a database will only work for certain issues, ...thus sometimes corrupting the db, ...even more (or worse wiping it completely)

Glad it helped
;-)

Jeff
0
pcelbaCommented:
Hmm... I didn't expect OpenOffice is so powerful. That's great!

Thanks for the points but I would rather re-transfer them to Jeffrey.
0
Jeffrey CoachmanMIS LiasonCommented:
Not sure if it is more powerful.
It may be just that MS may have changed the internal stricture of some file types, ...but Open Office retained the original structure.
Thus Certain MS Access EXE files might have trouble with the DB's made with the "old" structure...?

Just guessing here, ...but it was quiet a revelation.

Points can stay where they are because the your post is a fairly solid solution, that has been the solution form for many posts here.
;-)

Jeff
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.