MS Access run-time ...
 
Notifications
Clear all

MS Access run-time error

2 Posts
2 Users
0 Reactions
539 Views
(@aimosala)
New Member
Joined: 9 years ago
Posts: 1
Topic starter  

Hello,
I have a database .mdb which has got corrupted (Error 3197). I can't open it. I have tried and searched any solution, but apparently there is no one.
Can somebody help me, please?
By the way, I found this solution in EE and even tried AccessRecovery 2.1, but no success.
MS Access database recovery steps
1) Create a backup of the corrupt database. (Just in case of)
2) Create a new database and use File/Get external data/Import to get all objects of the damaged database.
3) Try these Microsoft solutions
Repair A97/A2000
http//support.microsoft.com/support/kb/articles/Q109/9/53.asp
Jetcomp
http//support.microsoft.com/default.aspx?scid=kb;en-us;Q273956
and/or read the article
ACC2000 How to Troubleshoot Corruption in a Microsoft Access Database
http//support.microsoft.com/default.aspx?scid=kb;en-us;306204
4) Bit "heavier"
Access decompile
http//www.granite.ab.ca/access/decompile.htm


   
Quote
jaclaz
(@jaclaz)
Illustrious Member
Joined: 18 years ago
Posts: 5133
 

Hello,…

Curiously enough another user had EXACTLY your same experience in 2005
https://www.experts-exchange.com/questions/21440605/Access-2003-Error-3197-and-there-is-no-solution.html

Let's wait until your friend spammer will post a link to a Commercial "miracle" solution …

jaclaz


   
ReplyQuote
Share: