Software

Ask something
Discussion Locked

Corrupt database

0 helpful
5 replies

by dmager2002

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an Access 2000 database in a multiuser (3 people) environment on the network. Database has become corrupt too many times. User receives the following message: "The database 'C:\My Documents\Case Management.mdb' needs to be repaired or isn't a database file. You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open. Do you want Microsoft Access to attempt to repair the database? Yes No. I have verified that no one else is in the database. Database is unable to be repaired when I click yes. I have had to restore the database from the previous day's network backup losing 1 day of work.

5 replies

by otl

One option is make a backup of the database, one at a time try to repair the database from each of the users computer until it is successful. You may have to restore the database once or twice, but it should be successful from the computer that Access "thinks" has a file open.

Another (not the easiest but the safest) is to create a new database file, import all existing data from the original database. verify it works then replace the original.

by joseph moore

I don't know if this will make any difference, but have you tried to repair it from the command shell?
Try this. First, make a copy of the corrupt version (I am calling it casemanagementcopy.mdb for this example). Next open up a DOS command shell window and (assuming Access is installed in the default directory structure) type:

c:\program files\microsoft office\office\msaccess.exe c:\my documents\casemanagementcopy.mdb /repair

You can also do a Compact command with the /compact switch.
I have had this kind of problem with a shared Access database. Access has problems in a multi-user environment. It corrupts easily. What I had to eventually do was set up a scheduled job that did the /repair and /compact every night. Irritating, yes, but it helped.

by dmager2002

Database is password protected which seems to make repair impossible. Database opens asking for password. Repair database message appears, then when I attempt to repair, another message comes up saying password is invalid. Corruption occurs when multiple users are in database and the network connection is lost, if even for a brief moment.

This discussion is closed to new replies.