Locked File with No user

[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?

 

[Dirk Goldgar]

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?

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?

 

[David Waldman]

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.

 

[Dirk Goldgar]

to answer a few of the questions...

yes there is and ldb in the directory

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.

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.