I am having problems changing my co

[ctau]

I am having problems changing my code from Access 97 to Access 2000. I am unable to connect to the database when I switch from one database to the other. Any help would be greatly appreciated. I am new to ASP and can't seem to get over this small hump. The code that I have been using for the 97 database is below.


dim myConnection
dim connectString

connectString = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=C:\test.mdb"

Set myConnection = Server.CreateObject("ADODB.Connection&quot
Set RSTitleList = Server.CreateObject("ADODB.Recordset&quot


thanks,
CTAU

 

[swilliams]

Try 3.60 instead of 3.51 - you must have the updated Jet engine on the server for it to work (the easiest way to do this is install Access2000 on the server).
Simon

 

[ctau]

Thanks that fixed the problem.

CTAU