Can't Open Database

  • Thread starter Thread starter Larry L
  • Start date Start date
L

Larry L

I recently networked several computers at my home office. Two machines
have Access 2000 installed. On machine A I have an Access database. When
I try to open it on Machine B it gives me an error message saying "Cannot
open the file. It is already opened exclusively by another user. . ." (It
isn't).

On further investigation I made a copy of it on Machine A and that opened
fine on Machine B. I then closed it, opened it on Machine A, closed it
and when I went back to 'B' it again gives me the same error message.
Re-booting 'A' doesn't fix the problem. I've never set any permissions,
or any passwords on either machine.

Anyone tell me what I'm missing?

Thanks,
Larry
 
Delete the ldb file in the same folder as your mdb file.

The ldb contains locking information. Usually Access deletes the file when
it closes, but if you crash, the locking file can contain spurious data, and
Access thinks it's still locked.
 
Go into the database security. Even though you have not
set up permissions in the database, there are places
within the security window set to exclusive use by
default. I had this same problem. I went through each
table, default database, etc. and made the change. Also,
check to see what rights are set for the admin on
databases already created and also on your default for new
DB, I found that caused a few problems as well.
 
Back
Top