>Hy Joe,
>
>If the CursorLocation property is set to adUserServer then then RecordCount property is always -1.
>
>You can change the CursorLocation to adUseClient or before create the recordset
>to excute an simple sql stament "Select count(*) as NumRecords From ...."
>
>Giuseppe
That is not exactly true. If the CursorLocation is adUseServer, the CursorTypes of adOpenKeyset and adOpenStatic properly set the RecordCount property. But it is true that if you set the CursorLocation to adUseClient then all CursorTypes report the RecordCount.
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
