Delete lock file when no body is in use will cause trouble later? "Frank" <tugz[ at ]yahoo.com> 04.11.2005 17:00:00 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.

Re: Delete lock file when no body is in use will cause trouble later? "seth" <seth[ at ]work.org> 04.11.2005 17:10:57 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 "Frank" <tugz[ at ]yahoo.com> wrote in message news:1131123600.118629.40370[ at ]g49g2000cwa.googlegroups.com... [Quoted Text] > 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. >

Re: Delete lock file when no body is in use will cause trouble later? "Frank" <tugz[ at ]yahoo.com> 04.11.2005 18:04:34 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.

Re: Delete lock file when no body is in use will cause trouble later? "seth" <seth[ at ]work.org> 04.11.2005 18:24:21 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 "Frank" <tugz[ at ]yahoo.com> wrote in message news:1131127474.600722.99030[ at ]g43g2000cwa.googlegroups.com... [Quoted Text] > 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. >