ldb file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Reggie - 05 Jul 2007 19:16 GMT

Hi and TIA. I have a backend db on my server. I often want to compact &
repair it, but cannot due to not being able to delete the ldb file. I have
a procedure from my frontend that checks logged on users. It indeed states
that several people are logged on when in fact I know that no one is. Why
is it showing them still logged on and how can I force them out so that I
can compact & repair the backend? I have a procedure that kicks everyone
off, but even running this I run into the same issue. I know I can copy the
backend to a new location, compact & repair, and re-establish the linked
tables, but that doesn't solve, explain or prevent this from happening. Any
advice is appreciated. Thanks for your time.

Signature

******************
Reggie

Reply to this Message

Douglas J. Steele - 05 Jul 2007 19:54 GMT

If the application was closed incorrectly (such as just shutting down Access
by clicking on the X in the upper right-hand corner, or shutting down the
workstation, the thread to the database may not have been released.

While a pain, you may have to reboot the server, and thus release all open
connections.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi and TIA. I have a backend db on my server. I often want to compact &
> repair it, but cannot due to not being able to delete the ldb file. I
[quoted text clipped - 6 lines]
> the linked tables, but that doesn't solve, explain or prevent this from
> happening. Any advice is appreciated. Thanks for your time.

Reply to this Message

Reggie - 06 Jul 2007 09:30 GMT

Thanks Doug! Is there a procedure that will force it to shut down when they
click the X or the workstation is closed whilst the app is still open?

Signature

******************
Reggie

> If the application was closed incorrectly (such as just shutting down
> Access by clicking on the X in the upper right-hand corner, or shutting
[quoted text clipped - 15 lines]
>> prevent this from happening. Any advice is appreciated. Thanks for your
>> time.

Reply to this Message