Discussion Locked

Cannot open Access 2000 database

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I received this message when opening a Access 2000 database. The Microsoft Jet Database engine stopped the process because you and another user are attempting to change the same data at the same time. Nobody else is using the database. I tried toimport the data into a new database with no success. I also tried repairing and compacting the database with no luck.

5 replies

by malewis1

If you look in the folder where the database is located do you see a file with an extension of xxxxx.IDB? If you do just delete this file and try opening up the database again. I have problems with this file not being deleted after someone exists the database. When this file exists Access thinks that someone else has it open.

by dliby

The xxxx.ldb file was deleted when the database was oriogional closed. Thanks, but that isn't the problem.
I restored the database from a backup, so I didn't lose any data.
I have no idea what kind of corruption occurred.

by nccorthu

Is the ODBC setup for the Jet Engine Ok and is it all current version.

Go to Control Panel\ ODBCdatasources and see if the Drivers are loaded.
If not loaded reload and if npothing else works reload them from the distribution or other sources.

by dliby

I don't see any problem with the odbc drivers. I had to
restore the corrupt database from a tape. It is working
fine. Since I cannot get the problem to recreate itself.
I don't know what caused the problem

This discussion is closed to new replies.