Why doesn't this work?

[damann]

query = "SELECT field1 FROM table1"
set objRS = Server.CreateObject("ADODB.Recordset&quot
objRS.Open query, adOpenStatic

 

[mot98]

Just a guess, but your open syntax should look something like this:
objRS.Open query, "DSN=Whatever", adOpenStatic

HTH's... mot98


"Every day I learn something new, and forget 10 things I learned long ago!"

 

[damann]

Well I aleady have the connection opened. Here's the full code:

Set objConn = Server.CreateObject("ADODB.Connection&quot
MdbFilePath = Server.MapPath("febs_dev_project.mdb&quot
objConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
Set objRS = Server.CreateObject("ADODB.Recordset&quot
objRS.Open query, adOpenStatic

This is what doesn't work. I don't understand why...

 

[travmak]

did you define adOpenStatic? i think it would be the same as
objRS.Open query, 3