Delete lock file when no body is in use will cause trouble later?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank - 04 Nov 2005 18:00 GMT

We have an Access database Sch.mdb in the shared driver S. I want to
make a change to the form and the code. However one user is always
login to that database and I am unable to make such a change. The
utility LdbView found that a computer named 1X23Y45 is login to the
database Sch.mdb all day long for three days. The user might forget to
close the database and left for a vacation, or there was a database
crash. I called the network administrator, he does not have time to
check where the computer 1X23Y45 locates.

The question: Can I ask the system administrator simply to delete the
lock file Sch.ldb after office hours when no body is supposed to use
the database so I can make changes to database?

It seems to me that the user login info is stored in the lock file
Sch.ldb AS WELL AS in the 1st page of the database Sch.mdb. If we
delete the lock file, the login info may still be left in the database
Sch.mdb. Will it cause some trouble later?

Thank you for your help.

Reply to this Message

seth - 04 Nov 2005 18:10 GMT

if the system crashed or access otherwise did not close properly then the
lock file will remain
if no one else has the database open and the lock file exists it can be
deleted

> We have an Access database Sch.mdb in the shared driver S. I want to
> make a change to the form and the code. However one user is always
[quoted text clipped - 15 lines]
>
> Thank you for your help.

Reply to this Message

Frank - 04 Nov 2005 19:04 GMT

So the system administrator will be able to delete the lock file even a
message shows something like "You can't delete....sharing violation"?
Thank you.

Reply to this Message

seth - 04 Nov 2005 19:24 GMT

as i stated before "if no one else has the database open and the lock file
exists it can be deleted"
if it says it can't be deleted because the file is in use, then someone has
the database open

> So the system administrator will be able to delete the lock file even a
> message shows something like "You can't delete....sharing violation"?
> Thank you.

Reply to this Message