Database is locked

[Guest]

When I check the status of a database Idb file on the explore page, it shows
locked even though no one has the database open. When I open the database it
will not permit any updates to forms, querys etc. When I check to see who
else has the database open, It shows my machine id multiple times, even after
I have re-booted. I just converted the databases from 97 to 2002. Another
fact is the databases have linked tables. Some of the links are to each
other. These dbs are in a multi-user environment, but I have ascertained that
no other user has the db open. I copied the databases to my hard drive just
so I could do a compact on them, but now am unable to copy the compacted data
bases back to the LAN server. How do I prevent this locked condition?

 

[Peter R. Fletcher]

Generally speaking, if you are _absolutely_ _certain_ that no-one has
a database open, you (or someone with sufficient privileges) can
simply delete the .ldb file to restore normal access to the database.
_However,_ the same event that resulted in the "orphan" .ldb file may
well also have resulted in damage to the database, so you should
definitely make a copy of it and then Compact and Repair the original
before doing anything else with it.

When I check the status of a database Idb file on the explore page, it shows
locked even though no one has the database open. When I open the database it
will not permit any updates to forms, querys etc. When I check to see who
else has the database open, It shows my machine id multiple times, even after
I have re-booted. I just converted the databases from 97 to 2002. Another
fact is the databases have linked tables. Some of the links are to each
other. These dbs are in a multi-user environment, but I have ascertained that
no other user has the db open. I copied the databases to my hard drive just
so I could do a compact on them, but now am unable to copy the compacted data
bases back to the LAN server. How do I prevent this locked condition?

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher