Tackle message Recordcount = -1 when usi

[Anon]

Hello
People using ADO to retreive records from a database often donot get the correct record count...This is because the cursor type of the database they use by default would be a forward only cursor....

Following is a workaround to tackle this problem
You need to Change your cursor type at the time of specifying your recordset
A sample code is given below

Set condb = application.CreateObject("ADODB.Connection")
condb.Open "eazy", "CBSI_EAZY", "CBSI_EAZY"
Set rs = application.CreateObject("ADODB.Recordset")
rs.CursorLocation = 3

After running this connection code...if you try to retreive the record count through the statement rs.recordcount, you will get the exact count for the DB
Hope this helps

Thanks
Soundar

[Anon]

Great solution!

Just fell into this problem when i went for a google search and there your article came up.

I was doing a VB application with a friend.
But a few questions:

why is adUseClient=3 and adUseServer=2...is this one of the microsoft discrepancies given that there are only two enums for the Cursorlocation property?

and anyway... how come you thought that was the problem.

I think i need tutelage. Please send your email.

Thanks a lot.