LDB Lock File location

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to specify where the .ldb lock file gets created when a
database is opened? When the database is in a read-only folder, the lock
file is not created. We'd like to put the lock file in a separate folder.

Thank in advance,
 
Glenn Suggs said:
Is there a way to specify where the .ldb lock file gets created when a
database is opened? When the database is in a read-only folder, the lock
file is not created. We'd like to put the lock file in a separate folder.
Click to expand...

No.
 
Hi Glenn,

I'm pretty sure there is no way to change the folder location of the lock
file. But looking further into your question, the lock file's location
doesnt seem to be your issue. Access requires users to have full rights on
the folder where the mdb file is located. This is by design, you should not
try to get around this.

Another reason why you should not try to get around this is, even if
hypothetically you could put the lock file in another folder, you would
still have problems running Access off of a read-only folder. So, even if
what you're asking for was possible, it still would not solve your problem.


HTH,
Immanuel Sibero
 
If the database is read-only, you don't need a lock file.

Try opening the database with a shortcut that specifies to open as Read-only
AND Exclusive (despite the sound of that, multiple users will be able to use
the database simultaneously)

You do this as:

"<full path to msaccess.exe>" "<full path to mdb file>" /ro /excl
 
What do you mean by "Hard Links", David. Are you implying that it IS
possible to set where the LDB file exists?
 
Would I do this? I'm already ashamed of myself for mentioning it. :~(
Just thinking about it reminds my why it would be a really bad idea.

(david)
 
Back
Top