Database will not open

[Rich]

We are trying to open a database created by a former
employee but are getting and error 'The Microsoft jet
database engine stopped the process because you and
another user are trying to change the same data at the
same time'. The file is stored locally and is not open
anywhere else. Compact and Repair gives me the same reply.
Is there any way of retrieving this file?

 

[Allen Browne]

Access stores the locking information in a small file with an ldb extension
in the same folder as the database. It generally deletes this file on exit,
but you may need to delete the file manually after a crash. If you can't
delete the ldb file, reboot the machine.

 

[charlesdaniel1]

Access stores the locking information in a small file with an ldb extension
in the same folder as the database. It generally deletes this file on exit,
but you may need to delete the file manually after a crash. If you can't
delete the ldb file, reboot the machine.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")

"Rich" <[email protected]> wrote in message
news:[email protected]...
> We are trying to open a database created by a former
> employee but are getting and error 'The Microsoft jet
> database engine stopped the process because you and
> another user are trying to change the same data at the
> same time'. The file is stored locally and is not open
> anywhere else. Compact and Repair gives me the same reply.
> Is there any way of retrieving this file?

Why don't you try to create a new database and import all the tables that are in the original file. If still not working out, you may try to link the tables after creating a new database and copy the fields and put them in another table which may help you though tiresome.