Aaron Bertrand, SQL Server MVP
Please reply in the newsgroups, but if you absolutely
must reply via e-mail, please take out the TRASH.
"Scott" <salexbaileymsn.com> wrote in message
news:eRxx3v9TDHA.2092TK2MSFTNGP10.phx.gbl...a> When using an access database, I could retrieve the recordcount with code
> For r = 1 to RS.RecordCount
> When I try the same syntax on a SQL database, the RecordCount always
> returns -1
> Is there another quick way to get the Record Count with SQL so I could run> similiar statement?