Could not use 'admin'; file already in use

G

Guest

I had developed two seperate databases that have been in
use for over 3 months. 3-4 people use them at at time.
Last week we started receiving the error above when trying
to open these files. No one is in the database when this
message comes up. Then a little later in the day, we are
able to open the files. Does anyone have any suggestions
on why this would be occuring now? I do have the admin and
users groups set up.
thanks
 
W

Wayne Morgan

When this happens, verify that no one is using the file then look for a
*.ldb file in the same folder with the same name as the file. If it is
there, delete it. Another possibility, is the time of day problem
consistent? If so, could the share permissions or user permissions where the
file is located be set to only allow access at certain times?

If the *.ldb file is consistently being left behind after everyone closes
the database, then you need to track down the problem. This is usually
caused not giving delete permissions (share and/or NTFS) to the users using
the database, but may also be caused by someone not properly closing Access
or Access crashing.
 
Top