File In Use error

[Guest]

I have a split database sitting on a server. I'm getting a "file in use"
message and am unable to open the database. There are no other users in it
(there's no locked db). Do you have any idea what could cause this?
Thanks

 

[Guest]

Are you saying that there's now .ldb file in the folder before you attempt to
open it? That doesn't necessarily mean no one is in the database. If they do
not have create permissions to that folder, they can still open the database
but not create the .ldb. Then you as the next person, can't get into it.

See if you can create a simple text file in the same folder as the database.
If not, you and maybe others can't create the .ldb.

 

[Guest]

I can create new files in the folder and there's a spreadsheet that I could
copy, but if I try to copy the database I get the file in use error. So it
doesn't appear to be folder permissions.

 

[Guest]

Copy the database file to your PC. See if you can open it up there. If not,
the file could be corrupted.

 

[punjab_tom]

do _NOT_ rely on MDB it is unpredictable

MDB is for lamers and retards
ADP is infinitely more scalable, stable, user friendly for developers
and users.

MDB doesn't even support full text search; and a table scan is not
acceptable performance

 

[Guest]

Actually, I found I couldn't even copy the database and had no access to it
which lead to finding out an independent IT contractor was doing a backup
that locked up the file. Thanks for your help!