Locked File with No user

  • Thread starter Thread starter David Waldman
  • Start date Start date
D

David Waldman

I have a .mdb file that is locked, but there is no user specified when I open it in Exlusive mode, it just says it's locked by another user. I need to swap out the database, but since it's locked I cannot do so. does anyone know a work around?
 
David Waldman said:
I have a .mdb file that is locked, but there is no user specified
when I open it in Exlusive mode, it just says it's locked by another
user. I need to swap out the database, but since it's locked I
cannot do so. does anyone know a work around?
Click to expand...

Do you see the matching .ldb file in the folder that holds the database?
If you're *sure* there's no user in the database, have you tried erasing
that .ldb file, and then opening the database?

Do you have full permissions on the folder containing the database? Is
this a local folder ot a network folder?
 
to answer a few of the questions...

yes there is and ldb in the directory

I'm sure that it is locked and it says that it is locked by my computer. I can tell this by attempting to to a compact and repair. If I shutdown my machine, go to another machine(as a different user), it says that that new machine has it locked even though it has never been opened by that machine.

The file is on a network drive and yes I have rights.

Thanks.
 
David Waldman said:
to answer a few of the questions...

yes there is and ldb in the directory
Click to expand...

Did you try deleting that .ldb file?
I'm sure that it is locked and it says that it is locked by my
computer. I can tell this by attempting to to a compact and repair.
If I shutdown my machine, go to another machine(as a different user),
it says that that new machine has it locked even though it has never
been opened by that machine.

The file is on a network drive and yes I have rights.
Click to expand...

It sure sounds like a permissions issue. All users must have read,
write, update, and delete permissions on the folder containing the
database. Frequently the need for delete permissions is overlooked.
Please confirm that you do have all these permissions.
 
Back
Top