moving the ldb file

[Guest]

Hi All

I have a database in a read only directory, the problem is that when somone
tries to open the file access creates a lock file (*.ldb) in the same
directory and that creates a problem. Is there a way that I can set up the
lock file to save to their local computer or indeed to a write part of the
server?

Thanks heaps
Jase

 

[Rick Brandt]

Hi All

I have a database in a read only directory, the problem is that when somone
tries to open the file access creates a lock file (*.ldb) in the same
directory and that creates a problem. Is there a way that I can set up the
lock file to save to their local computer or indeed to a write part of the
server?

Nope. Users need file create, file edit, and file delete to any folder where
the front end, back end and mdw file are located.

 

[Guest]

There are 2 ways around this problem:

- open the mdb to create the ldb with your account; have network admin set
the ldb to be non-deletable; close the mdb; the ldb should remain in that
folder

- run a dummy app 24/7 that opens a form that links to the mdb you want;
this keeps the ldb open all the time; of course you need to run this under
your account or in an app server with admin account.

 

[Douglas J. Steele]

You won't be able to compact the database if you do either of these.