Hi all

I have just developed a website using DW8/ASP/MS Access for the company I work for. Since uploading the site I have discovered that the loading times for dynamic pages go down to a crawl at certain times of the day.

I have checked that all my recordsets are closed (DW8 closes them at the bottom of every page), and I have changed from a OBDC connection to a OLEDB one because I have read that it is faster. All of the sites images have been optimised.

I have read on Google that you should close DB connections also. Could that be the problem?

Here's the connection that I am using;

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_connCuthbertson_STRING
MM_connCuthbertson_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=my path on server\xx\xxx.mdb;"
%>

I'm running out of ideas on what else to look at. Any help would be appreciated.

Glenn