File already in use - how to solve?

[Andrey]

Hi,
could you help me to solve the problem:
I have MS Access 97 data file (mdb) on server and a list of MS Access 97 and
MS Access 2000 files (mde), linked to it and located on workstations. I.e.
one data source and many interfaces. All files opened NOT in exclusive mode,
but time up to time some user receive message like "Couldn't use
'T:\...\Tables.mdb'; file already in use" while trying to run the interface
file (from local PC).

Thank you
Best Regards
Andrey

P.S. Users of interface files have at least read-write-execute access to
data file on server.

 

[Al Borges]

Hi Andrey:

Check the folder for a *.Idb file that is a lock file that is supposed to
get deleted when you power down the open Access database. Sometimes it's
left behind. Just simply delete it and your problem should be solved...

Al

 

[Andrey]

Al,
Thank you very much, I'll try next time it happened.
Could you tell me how I can delete ldb file, if one or more users already
open the database?

 

[Gijs Beukenoot]

Andrey stelde dit idée voor :

Al,
Thank you very much, I'll try next time it happened.
Could you tell me how I can delete ldb file, if one or more users already
open the database?

You can't when it's in use...

I guess that brings you back to the original question then... Have
alook where exactly it goes wrong (on error routines) and see if you
can trap the error and perhaps retry the action.