I know that when you use an MDB file the lock file appears in the same directory. We have split the database and are using mde files with SQL Server tables. Because it is Access there must be a lock file somewhere but where is it save? Is it in the users directory c:\Documents and Setting\username\.. ? In the past we would have users computers crash and lock open the database. Recently we had one table locked by something, the users keep getting messages that all of the records were in use.