Using an OLEDB connection instead of going through ODBC works considerably better under medium loads in IIS.

For an Access 2000 database your connection string would look like this..

MyConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../data/data.mdb"),"userid","password"

or

MyConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\databases\data.mdb"

For an Access 97 database just change the 4.0 to 3.51. You'll also need to download and install MDAC 2.5 RTM (www.microsoft.com/data)