Access 97 - external dll gets outdated data - what can i do?

Question

Hello,

In my current job i have to fix some issues in an old Access97-application. My last problem is this: Some reports are created with an external dll and sometimes the reports are wrong. They contain data from the previous call or the detail data is missing and so on. If i start the same report without any change on the data the reports are correct.

The cause for this is in my opionion, that the external dll gets outdated data from access instead the current data, which is written just before calling the dll. Is there any documented way to flush the internal buffers from access or do i have to add some wait cycle in the hope, that it will avoid this problem in most of the times?

Thx,
Thomas G. Liesner

Answer 1

There are several Access level settings that control this. ExclusiveAsyncDelay and SharedAsyncDelay. The ExclusiveAsyncDelay default setting is 2000 milliseconds or 2 seconds. Thus, assuming your app is the only one accessing the database, is likely your problem.

You can search in the Access 97 help for these keywords tor instructions on making these changes permanently to the registry. This will require admin privilages.

Or better yet use the dbengine.SetOption to temporarily override the settings for your database. Note that you will have to execute the dbengine.setoption method at the beginning of your code that updates the database in question.