Re: Error - System.Data.OleDb.OleDbException: Could not use ''; file already in use. - please help

PS: make sure your ASP account can create files in the same folder you MDB
file is.
Access driver creates ldb file which has locking information. Without it
your database will be opened in single user mode

George.


"Learner" <pradev@xxxxxxxxx> wrote in message
news:1137184467.824467.25690@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> HI joey,
> I thought i already replied to it. I am sorry about that. Yes it did
> work for me and my bad i never closed the connection object.
> thanks for the help
> -L
>


.

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: RE: ADO:VB6 Object not opened error. Guidance please?
    ... I am using most recent Jet. ... Access '97 .mdb ... MS access driver ... ALSO - I can not get access 2000 created databases to work at ...
    (comp.lang.basic.visual.database)