I am using MS Access 2002 as my backend database, and an ASP application as my frontend.
Here is my ADODB connection string:
set oConn = Server.CreateObject("adodb.connection")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
at the end of each page, I have this:
set oConn = nothing
Everything will work fine for awhile, and then asp requests to the database (update, select, insert, etc.) all time out - and takes about 10 minutes before everything clears up. HTML pages without ASP code still work fine - but the ASP coded pages stop working. I can either wait for it to clear itself out, or I can restart IIS and it clears itself out. And then happens in about 30min to an hour or so.
The fact that ASP code works for awhile tells me my code is fine. I have applied the latest patches for Jet, to no avail.