Access lock file with mde

[Guest]

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.

 

[Douglas J Steele]

The lock file is always in the same folder as the MDB or MDE. There's no way
to change that. You can, however, prevent the lock file from being created
if you open the database as read-only and exclusive (and it's possible to do
this through a shortcut, if that's how your users are opening their
front-end)

Since your data is in SQL Server, any messages about locking would relate to
SQL Server, not the front-end.