 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / March 2006Corrupt database can't repair
I have an AC2000 Database running in AC2k3 that users are now getting this error: The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time When I try to open it to repair I get the error, when I try jetcomp.exe it gives an error, when I try to import the objects I get the error (In fact it doesn't let me choose objects, it won't even open it up to view them). No matter which way I try to access the data it won't let me. I am having the last backup restored from the network backups, but I need to know if there is any way to recover the data that is in the bad database? Have you tried importing the objects one at a time?  SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html >I have an AC2000 Database running in AC2k3 that users are now getting > this error: [quoted text clipped - 10 lines] > need to know if there is any way to recover the data that is in the bad > database? Yes ... When I choose this database for import it give the error and doesn't show the listing of objects. Your database may be corrupted beyond repair. You might check with one of the Data Recovery services mentioned on the following website to see if they can help you out. http://www.granite.ab.ca/access/corruptmdbs.htm SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html > Yes ... When I choose this database for import it give the error and > doesn't show the listing of objects. That's what I had feared, I just wanted to make sure. Thanks for your help. We have the database being restored, and have only lost 1 day's work. Maybe it's time to move this to a SQL Server backend. You're welcome. Best wishes with it. SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html > That's what I had feared, I just wanted to make sure. > > Thanks for your help. We have the database being restored, and have > only lost 1 day's work. > > Maybe it's time to move this to a SQL Server backend. This memory is several years old and very foggy, so take that under advisement: Make sure you try to "fix" the back end first. I remember a case where the corruption was in the backend (easily fixed with a compact) but there was no way to get into the frontend (even to import objects) until that was dealt with. Once the backend problem was fixed, all problems were fixed (i.e., the frontend no longer had any issues). HTH, SignatureGeorge Nicholson Remove 'Junk' from return address. > Yes ... When I choose this database for import it give the error and > doesn't show the listing of objects. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.