Pablo Software Solutions

[pduncan]

I am making an ADO connection to access. When I am done, I close and destroy my connections (I think?) but the Access database remains open. The only way I can get rid of the .ldb file is to stop the web server.

I end the code on my page with

[pduncan]

I found the solution...

remove "server."

Server.CreateObject("ADODB.Connection")

and

Server.CreateObject("ADODB.Recordset")

[admin]

Using
Server.CreateObject("")
will cache the database connection and adds a reference to the server's internal dispatch list.

Always use
CreateObject("ADODB.Connection")
unless you have a good reason to use Server.CreateObject("")
(for example event processing of ASP plugins)