[AccessD] recordset count = -1?

Is it client side or server side cursor?

>From DEVX forum - 

"RecordCount for server side cursors returns "-1".

oRS.Source = SQL_str
oRS.CursorLocation = 3 'adUseClient
oRS.Open" 


Perry Harold
Professional Testing Inc


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Monday, November 12, 2007 3:10 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] recordset count = -1?

Oh my... this is an old one Arthur -- so old, I can't even remember the
exact cure -- I think it has to do with the type of cursor. I wrote
about it years ago, I'll see if I can find the article. Charlotte will
know. Maybe she'll see this.

Susan H.



> I've got a DAO recordset and codes that does rs.moveFirst and 
> rs.MoveLastand debug.print rs.RecordCount, but it consistently returns

> -1, when I know there are records in the set. What am I doing wrong?

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com