Access / ASP Slow Web connection

[ronron66]

I'm using an access DB as a back end of a Web application. Sometimes, the web page is very slow comming up ( 40 - 120 secs) I troubleshooted the page
and determined that the slowness is in the Open connection command; See code below.

connectstr = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & db_path
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open connectstr

Any thoughts on whay this command would take so long to execute?

Thanks

[puppydogbuddy]

Not sure, but the example given in this link uses the activeConnection property. Try using the activeConnection property in your code, and see if it helps.

http://msdn.microsoft.com/en-us/libr...utorial_topic1

Excerpted from link:

'Connects to the Access driver and Access database in the Inetpub
'directory where the database is saved
strProvider = "Driver={Microsoft Access Driver (*.mdb)};
   DBQ=C:\Inetpub\Wwwroot\Tutorial\guestbook.mdb;"
'Creates an instance of an Active Server component
set objConn = server.createobject("ADODB.Connection")
'Opens the connection to the data store
objConn.Open strProvider
'Instantiate Command object and use ActiveConnection property to
'attach connection to Command object
set cm = Server.CreateObject("ADODB.Command")
cm.ActiveConnection = objConn