Error on DB open - Jet Engine stops (HELP)

[Mike]

Hello,

I am getting this message on a DB on open "The microsoft
Jet Database Engine stopped the process because you and
another user are attempting to change the same data at
the same time". There are no other users accessing the DB.

I can't seem to repair the DB or get it to open. Have
copied it to another computer not on the network, and
have the same problem (No other users are possibly in the
DB) Seems to be a lock within the DB itself. Other DB's
open without any problem on both systems. Have also tried
to import the tables from the affected DB into another
copy of the DB which is an older back-up and opens with
no problem, but same message occurrs.

Is there any way to repair the DB and get it open? Or
force the Jet Engine to run?

 

[Kristyn Wagoner [MSFT]]

Typically this error message indicated corruption in the database. To
combat corruption, there are a couple things you can try.:

*Backup your database first using Windows Explorer.

- Compact the database using Tools/Database Utilities/Compact and Repair
- Create a new database and use the Import process to import all the objects
from the old database into this new one.
- Update the version of Jet; Compact and Repair again.
- Or you can run a utility called Jetcomp.exe that may sometimes repair what
the above does not.

You can find information on repairing databases in the following article:

Q306829 - ACC97: How to Troubleshoot Corruption in a Microsoft Access 97
Database http://support.microsoft.com/support/kb/articles/q306/8/29.asp

Q306204 - ACC2000: How to Troubleshoot Corruption in a Microsoft Access 2000
Database
http://support.microsoft.com/support/kb/articles/q306/2/04.asp

Q304701 - ACC2002: How to Troubleshoot Corruption in a Microsoft Access 2002
Database
http://support.microsoft.com/support



--
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

This posting is provided "AS IS" with no warranties, and confers no rights.