MSAccess connection buildup

[wduty]

I have an asp website running on NT/IIS4 which uses an Access database. The server is fast and normally the website is very speedy.

However, after a while (1 - 2 months) connections to the access database build up (there is usually an ldb file with 4 - 6 admin connections). These connections won't go away and performance is severely slowed on the pages which call the database. The only thing which I have found effectively clears this is restarting the server.

I went through the entire site and made sure that all ADO connection and recordset objects are closed and set to nothing after use. However, this doesn't seem to fix the problem. Is there something else this could be? There are no objects in sessions (I'm not even using sessions except in the content management area of the site, and that only for passwording).

Has anyone seen this problem? I don't even know where to begin looking. Any help would be immensely appreciated.


--Will Duty
wduty@radicalfringe.com

 

[DougP]

So what do you do to fix the problem?
Reboot?
Delete the .LDB's?
I suppose "Admin" is the user because the Server is opening the database?

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[wduty]

Yes, restarting the server seems to be the only thing which takes care of the problem. The server won't let me delete the ldb file. Either way, I haven't had this problem before (on other servers with the same set-up) so it's seems like it is something specific.

--Will Duty
wduty@radicalfringe.com

 

[MichaelRed]

Will, are you making sure the connection(s) are properly closed when error(s) are processed?



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[wduty]

Would having an ODBC or ADO error without a subsequent connection close cause this problem? I haven't been using error handling because I'm using an version of asp prior to the intrinsic asp error object.

--Will Duty
wduty@radicalfringe.com