Discussion:
Access mdb: avoid ldb w/o locking the file
(too old to reply)
Andy DF
2005-09-14 08:19:29 UTC
Permalink
I want to connect to an Access 2000 mdb without having the lock file created
(.ldb) and still be able to perform file system operations on the mdb file
while connected.
Skipping the ldb file creation can be achieved by connecting to the database
in exclusive mode.
Unfortunately this method also locks the mdb file and normal file system
operations (copying and binary reading/writing) fail.

Is there a way to avoid ldb files and still have access to an mdb file WHILE
CONNECTED?

TIA,
Andy.
Brendan Reynolds
2005-09-14 11:45:36 UTC
Permalink
I don't believe there is, and if you should find a way, the result is likely
to be a corrupted MDB.
--
Brendan Reynolds (Access MVP)
Post by Andy DF
I want to connect to an Access 2000 mdb without having the lock file
created (.ldb) and still be able to perform file system operations on the
mdb file while connected.
Skipping the ldb file creation can be achieved by connecting to the
database in exclusive mode.
Unfortunately this method also locks the mdb file and normal file system
operations (copying and binary reading/writing) fail.
Is there a way to avoid ldb files and still have access to an mdb file
WHILE CONNECTED?
TIA,
Andy.
Loading...