sql server .recordcount

[beaniebear]

I am trying to get the record count of a recordset of data from SQL server. I seem to have tried every combination of cursor type and lock type but still getting a 'Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another'. Could someone please advide which combination I should use?#

Thanks,Jo

 

[ChrisHirst]

it's objRS.cursorlocation = adUseClient that does the trick



Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[beaniebear]

Doh! Silly me! Please ignore my question. I just realised I had not included the adovbs.inc now all works fine. I blame it on my pregnant state.

Thanks anyway, jo