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