[AccessD] ado recordcount

Jim Lawrence (AccessD) accessd at shaw.ca
Sun Oct 19 10:05:40 CDT 2003


Hi John:

In addition to the information supplied by Dave Sharpe with using a server
side cursor location will cause issues. Use 'rs.CursorLocation =
adUseClient' instead of 'rs.CursorLocation = adUseServer'. Most work can be
done with 'static' cursor types. Use adOpenKeyset type cursors only when
updating or deleting and use a pessimistic lock so as to not over-write a
record being used by another.

My two cents worth
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Colby
Sent: Saturday, October 18, 2003 8:38 PM
To: AccessD
Subject: [AccessD] ado recordcount


I am opening a recordset (raw table) that contains records.
Move last, move first.
EOF and BOF are both false.

Recordcount = -1

What gives?  How do I tell how many records in the recordset?

John W. Colby
www.colbyconsulting.com

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



More information about the AccessD mailing list