Record locking information file

[chiefvj]

Everytime you open an Access database( a backend with the tables for example) a Record-Locking Information file is created. That file is deleted when the database is closed.....True?
Here is the problem...if the backend database is in a folder with limited permission ie. can delete records but not modify the content of the folder..then that Record-locking file is never deleted...In addition, you cannot "compile on close" because the backup file created in the compiling process cannot be deleted.
My question... is there anyway to suppress the creating of the Record-locking file?

 

[alvechurchdata]

Microsoft at

http://support.microsoft.com/kb/109957

say:

Normally, the .LDB file must be in a directory where the user has
read-write permissions. However, it is possible to open a database
in a directory or device where a user has read-only permissions.
To do this, select both the Read Only and the Exclusive check boxes
in the Open Database dialog box. The Open Database dialog box can
be found by selecting Open Database from the File menu. The
combination of read-only and exclusive means that users will not be
updating any database information, so record-locking isn't
required. Because record-locking isn't required, Microsoft Access
does not attempt to open or create an .LDB file.

But this refers to Access 1 & 2. Let un know if it works for you.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[chiefvj]

thanks i will give it a shot

 

[dhookom]

I doubt any users other than maybe the first person in, will be able to change any records.

Is there a good reason why permissions can't be adjusted to enable proper use of Access? That's just the way Access works.

I like to think of the [red]l[/red]db [red]l[/red]ights file. An Access MDB is a storeroom with no windows. The first person in the room (user) must turn on the lights (create the ldb) so other people (users) can see so they don't bump into each other or grab for the same stuff. When the last person leaves the room, he/she turns out the lights (deletes the ldb).

Duane
Hook'D on Access
MS Access MVP