sjlevine34
asked on
RecordsetClone recordcount erroneous in Access 97 application
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.record count). 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?
sjl
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
This error is rendering this critical application unusable. Any ideas as to what is happening here?
sjl
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad you got your problem resolved. Thanks for points and grade.
ASKER
sjl