Creating an OLEDB Connection

[admin]

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

For an Access 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"

Note:
If you get a Provider Could Not Be Found error then you'll need to download MDAC 2.5 RTM (www.microsoft.com/data)