Thanks Justin. I've just had another look and the ldb is still there (5
hours later). But this time I managed to delete it using Explorer. So maybe
your timeout has somthing to do with it (my session is set 30 min at
present). Or maybe because I reboot the computer? Funny thing though is I
have similar problem with plain old Access sometimes (different computer at
work) and it needs a reboot to fix. It would be good to find a shortcut
though : )
"S. Justin Gengo" <sjgengoaboutfortunate.com> wrote in message
> The ldb file will eventually time out. It takes a while though. I'll seeis> I can find any way to set it's timeout period to be shorter, but my guessperiod> that it may be tied to the session object which would have a timeoutand> of 20 minutes by default unless set otherwise. I'll experiment a littleif> see if this is the case.
> S. Justin Gengo, MCP
> Web Developer
> Free code library at:
> "Out of chaos comes order."
> "Sabre" <maximNOSPAMwave.co.nz> wrote in message
> news:uXKULC9UDHA.1680tk2msftngp13.phx.gbl...> > Hello All
> > For some reason my Access XP record locking file is not clearing. Evenmeans?> I> > use Explorer and manually open the mdb and then close it, ldb is still
> > there. Is there any way to delete the file using Explorer or other>> > Any thoughts on why ldb sticking? (I'm opening database in code, with
> > password).
> > Thanks!
> > Graeme