Cannot extract data

Question

I created some tables in my database some days ago, I worked with it till today. Some hours ago, I've opened my .mdb and I got...Cannot open database 'Dan3.mdb'. I applied Compact&Repair function, but it didn't aid. I've no idea how to extract data from table. I am on MS Access 2010.

Answer 1

Sounds like it got corrupted somehow. Did you happen to make a backup copy? Otherwise, you might have to try a third-party recovery program.

Just a thought...

Answer 2

This sounds like a good question for the Microsoft Community. Also note that there are plenty of previous answers to be found.

---

Sam Hobbs
SimpleSamples.Info

Answer 3

What version did you create the database in? You say you are using 2010, but hte file name extension is .mdb which tells me it was created in an earlier version. Did you create the new tables using 2010?

Answer 4

Hello,

Did you get any error message while opening the database? If it does, please detail the error message so we could get more about the issue.

Besides, did you update your office recently? What happened "some hours ago"?

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 5

I created some tables in my database some days ago, I worked with it till today. Some hours ago, I've opened my .mdb and I got...Cannot open database 'Dan3.mdb'. I applied Compact&Repair function, but it didn't aid. I've no idea how to extract data from table. I am on MS Access 2010.

It seems your database is corrupted, if so, visit Google, for example use this one phrase how to repair mdb file corrupt. On it I found guide below or some useful articles, guides, tips...

http://allenbrowne.com/ser-47.html

http://allenbrowne.com/recover.html

https://onlinefile.repair/en/access.html

Recovering from corruption

This article may help if your database is already corrupt

Before doing anything else, make a copy of the corrupted mdb file while Access is NOT running, and without overwriting any earlier backups. This lets you try different approaches and sequences if necessary.

Next, try the built-in repair utility. This very simple solution may work with corrupted indexes, and might even get rid of a corrupted object:

If this does not work, follow the steps for the symptoms of your corruption below.