I have created a small application as a test harness to troubleshoot a larger potential problem.
Here is my harness:
- VB6 application, with 1 form, and a .bas module referencing DAO 360
- MS Access 2003 DB, with one table (Employees) containing 2 records.
- Process Monitor running, with the filter set to my exe name
In the .bas module I have created public variables for the workspace, database and recordset objects.
In a command button on the main form I create the workspace, open the database, create a recordset, itterate through the recordset displaying the field values, all is well.
The problem is that until the database is closed I can see (Via Process Monitor) that there are 2 hits against the DB every 5 seconds (FASTIO_READ and FASTIO_CHECK_IF_POSSIBLE)
Can anyone off insight as to why this is happening, and is this by design in a DAO Setup?