RecordsetClone recordcount erroneous in Access 97 application
Posted on 2006-07-21
We have an Access 97 application running on Windows 95 that is hanging. It has both the front end application and a rear-end database.
To diagnose what was going on, I used an access database that I had written and used before to set the startup settings to default, so that, when opened, the database window opens without any screens. Running the application under Access 97/Win 95 in debug mode, the program erred when attempting to obtain a recordcount from the recordsetclone of the screen being used. Although the recordsource table only contained 3361 records, values for recordsetclone.recordcount were in the millions and different each time the value was queried in the debug window (?me.recordsetclone.recordcount). When this same maneuver was repeated in a copy of the application upgraded and running under Access 2002/Windows XP professional, the same recordcount, when queried in debug, was a repeatable 3361.
This error is rendering this critical application unusable. Any ideas as to what is happening here?