Charlotte Foust
charlotte.foust at gmail.com
Wed Aug 4 22:24:51 CDT 2010
Lock files are associated with mdb and accdb file formats. If you have one that doesn't get deleted when the connection or database is closed, it usually means that the last person out of the database did not have delete permissions on the folder where the lock file lives. Charlotte Foust On Wed, Aug 4, 2010 at 12:56 PM, Brad Marks <brad.marks1 at gmail.com> wrote: > All, > > We have never paid a lot of attention to the Access 2007 Laccdb lock file in > the past. > > Recently we have run into some issues and I am trying to get up to speed > with this file and how it works. > > We are using a Windows Terminal Services environment. We have a small > number of scheduled jobs that automatically run Access Reports and then > Email them at night. No user is logged on when this happens. > > At appears that one of our scheduled jobs did not run properly and now we > have an Laccdb file that we cannot delete. > > If we open with Laccdb file work notepad, we see this info > > > TS Admin TS Admin > > > > How can we delete this file? > > It appears that our automated jobs will still run, even with this lock file. > > We have done some experimenting and we can see how the lock file prevents us > from making any changes to a form or report. It appears that such things as > Append Queries will still run, however. Is this true? > > Is there a way to force Access to not write a lock file. The end-users are > all using an accdR version of the system. They are therefore not able to > make any changes to the application, they can only use the application. It > seems like we really don't need any lock protection for this application. > Is there a way to turn it off so that we don't have to deal with this > problem in the future. > > Thanks in advance for your help. > > Brad > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >