Access ldb file not removed

[Blim]

A script I have created leaves an Access ldb file on the server after it has
run, and I am worried that this meand that resources are not being released.

I am using asp to read data from an Access database to populate some menus.
The asp script uses ADO to read three recordsets, each of which is then closed
and the recordset objects set to Nothing. After running the script, an ldb file
is left on the server (the mdb file is Menus.mdb, the created file is
Menus.ldb). I understand why the ldb file is created: it's a file locking table
and Access creates one whenever data is accessed. However, I thought that the
ldb file would be removed after all the relevant objects had been closed.

The recordsets use a connection string, in statements of the format:

rstMenu1.ActiveConnection = cnnMenus

where cnnMenus is the connection string to the Menus mdb. I don't create a
connection object as such, so I don't have anything to close. Is there a
connection object created for me? If so, how do I close it and will that get
rid of the ldb file?

Thanks

Ian

[Speegs]

Restart the server

[Blim]

Hi Speegs,

The server in question is my laptop, running IIS. This gets rebooted quite a
lot, but the problem remains. I can get rid of the ldb by opening the mdb in
Access, then closing Access. If I then run my asp script the ldb returns.

Ian