[AccessD] recordset count = -1?

  DAO recordsets return -1 on forward only and snapshot sets.  Also a set on
a linked tabledef will always return -1 when you open the recordset with the
table option.

Jim. 

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

Are you sure it's a DAO recordset, Arthur?  ADO recordsets commonly
return 0 or -1.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Monday, November 12, 2007 11:47 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] recordset count = -1?

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?

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

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