db locked by another user

6 Apr 2005 2:03 AM

BigDDDD

HELP! A co-worker's pc crashed while in this db. Now, he and I get the
following message when we try to open it: "The Microsoft Jet database engine
cannot open the file. it is already opened exclusively by another user, or
you need permission to view its data". I am the owner of the db.

I have tried and failed at:
- no file in that directory w/ an incorrect extension
- making a copy of the mdb, but the copy gives the same error message.
- using jetcomp resulted in error
- can't import or link tables from the source

6 Apr 2005 11:17 AM

Scott McDaniel

What do you mean by "no file in the directory with an incorrect extension"?
Do you mean the .ldb extension? That's not an "incorrect" extension, it's a
Locking file created by Access. If you did find one, delete it.

Also, if this is a split database, then check the backend location for a
file ending in .ldb. If you find it, delete it (note: you may have to do
this from the workstation that created the lock)

If you don't find this, and the other items you indicated didn't work, you
may need to contact a data recovery service.

Show quote

"BigDDDD" <BigD***@discussions.microsoft.com> wrote in message
news:76F03C42-0663-45A2-B811-943BC13E1E17@microsoft.com...
> HELP! A co-worker's pc crashed while in this db. Now, he and I get the
> following message when we try to open it: "The Microsoft Jet database
> engine
> cannot open the file. it is already opened exclusively by another user, or
> you need permission to view its data". I am the owner of the db.
>
> I have tried and failed at:
> - no file in that directory w/ an incorrect extension
> - making a copy of the mdb, but the copy gives the same error message.
> - using jetcomp resulted in error
> - can't import or link tables from the source

db locked by another user - error 3051