Re: Access mdb: avoid ldb w/o locking the file



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)

"Andy DF" <nospam@xxxxxxxxxx> wrote in message
news:4327dd0d$0$8487$5fc30a8@xxxxxxxxxxxxxxxxxx
>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.
>
>


.



Relevant Pages

  • Re: Can I make Linked Table Read-Only
    ... mdb, it tries to create an ldb file with the same name. ... permissions, you can open the mdb, but if you don't have write permissions, ... I understand your concern about using another department's folder. ... .LDB file, however, the others still get a "file is in use" error and can not ...
    (microsoft.public.access.gettingstarted)
  • Re: Unlocking of file on server
    ... Joe Richards Microsoft MVP Windows Server Directory Services ... > releasing the .MDB without having to reboot? ... > the .LDB file remaining open. ...
    (microsoft.public.win2000.advanced_server)
  • Unlocking of file on server
    ... I am not a LAN administrator and I am seeking some ... releasing the .MDB without having to reboot? ... the .LDB file remaining open. ... That is not always convenient for a server. ...
    (microsoft.public.win2000.advanced_server)
  • Re: Error 3045
    ... All users need create and delete permissions on the folder where the mdb ... This is so they can create/delete the associated ldb file. ... Brigitte P wrote: ...
    (microsoft.public.access.security)
  • Re: Error - System.Data.OleDb.OleDbException: Could not use ; file already in use. - please
    ... make sure your ASP account can create files in the same folder you MDB ... Access driver creates ldb file which has locking information. ...
    (microsoft.public.dotnet.framework.aspnet)