cannot access mdb file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lee Taylor-Vaughan - 18 Apr 2004 02:50 GMT

Help! (please)

I am trying to open my .mdb file and i am getting the following error upon
opening it:

"the microsoft jet database engine stopped the process because you and
another user are attempting to change the same data at the same time"

after i click ok the datbase exits.

i tried to compact/repair the database, but i get an 'excusive' needed
error.

I tried holding down the shift key when double clicking the mdb file --still
get the same error.

i tried creating a blank database and then importing the tables, i get the
same error as above when i select the database.

this file is on my lap top, there are no other people, or user accounts
trying to open this file.

does anyone have a solution, PLEASE.

TIA

Lee

Reply to this Message

SteveS - 19 Apr 2004 12:09 GMT

> Help! (please)
>
[quoted text clipped - 23 lines]
>
> Lee

Lee,

Whenever you open an Access database, a file with the same name as the
database and an extension of LDB will be opened automatically. This
new file keeps track of users and the objects that require some form of
locking in the database. When all users have exited gracefully from the
database, the LDB file is closed down and deleted. If users don't exit
gracefully, the LDB file is not deleted. The next time the MDB tries to
open, it sees the LDB and the MDB will not open.

Look in the directory that the MDB is in and see if there is a .LDB
file. If so, delete it and try and open your MDB.

HTH

Signature

Steve
--------------------------------
"Veni, Vidi, Velcro"
(I came, I saw, I stuck around.)

Reply to this Message