VB reports the wrong number of records from an Access database with the RecordCount property. The same query to dBase files reports the correct number of records. What is the problem?
Do a MoveLast followed by a MoveFirst on the dynaset or snapshot you created. That should take care of an invalid recordcount. Example:
rs.MoveLastrecCount% = rs.RecordCountrs.MoveFirst