Connection

[cabobound]

I am trying to get a record count without having to loop through with a counter. I believe the problem is with the connection type. I am not having any luck looking on the internet.

Here is my current connection.....

Set bConn = Server.CreateObject("ADODB.Connection")
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=dsntemp & "DBQ=" & server.mappath("MyDatabase.mdb")
bConn.Open DSNtemp

Does anyone have a suggestion?

Thanks in advance....
K

 

[tsuji]

Add this line after bConn.
[tt]
Set bConn = Server.CreateObject("ADODB.Connection")
[blue]bConn.cursorLocation=3[/blue] 'adUseClient=3
'etc etc...
[/tt]