LDB Lock File location

[Glenn Suggs]

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,

 

[Rick Brandt]

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.

No.

 

[Immanuel Sibero]

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

 

[Douglas J. Steele]

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

 

[Guest]

Yes.

Hard Links

(but see Doug's reply)

(david)

 

[Douglas J. Steele]

What do you mean by "Hard Links", David. Are you implying that it IS
possible to set where the LDB file exists?

 

[Guest]

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)

 

[TC]

Yea for asking! I was going to, but I though that I might be the only
person who did not know.

TC (MVP Access)
http://tc2.atspace.com