Unable to get Access to Close .ldb file

Hello: 

I run a website that uses MS Access, ASP.NET and VB. 

The DB is located at our ISP. 

Access opens a .ldb file, which for months now, closed on it's own in a few hours. 

Recently, the .ldb file NEVER goes away. 

I do not have the ability to remotely log into the ISP and open and
close the file, nor re-boot the server.

If the .ldb file does not close, I am unable to FTP a new version of
the DB up to the site.

I have tried to make sure any ADO calls have been closed properly.

-al

---

Request for Question Clarification by hummer-ga on 05 Oct 2004 06:32 PDT

Hi sunmoon,

See if this MS article helps...

ACC: Microsoft Jet Utilities Available in Download Center:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;176670

and this...

.mdb temp file (ldb) not destroyed after closing database conn - HELP!
http://forums.devshed.com/t115012/s.html

Good luck,
hummer

Just fyi, a .ldb file is indicative of the associated .mdb being in
use. While a user is connected to the .mdb file (which has your data),
Access creates a .ldb file to indicate that the .mdb is "locked".
"Locked Data Base" is essentially a flag that says "you can't change
tables or form structure in the .mdb while it's locked," among other
things.


My guess is that you may have one or two connections that have
attached to your .mdb and not have released, *probably* due to the
site being active.

Since this file is more of an indicator of status than something of
"value", like data, you may try to delete/rename the .ldb file and see
if that helps you. I'm gathering from your question that the data in
the .mdb isn't too valuable on the website side considering you're
attempting an inplace FTP update, but I'd still suggest you consider
renaming both the .mdb and .ldb prior to update, just in case.

This is a free comment.