Click to See Complete Forum and Search --> : Does MSAccess cache data on INSERT?


andreasen
June 4th, 2004, 08:43 PM
I have an application that is using a simple MSAccess database for input storage from a device. The code is set to write each data to the DB as it is received. I am running into a situation where I receive thousands of data points in a short period of time (<second) and when I inspect the DB I find the initial chunk of data is missing. I have debugged the logic and watched the INSERT queries be performed for the missing data without error, but after the sequence is ocmplete, and I inspect the DB directly, the data is missing.

Is there a limit or some sort of "flush" that I need to include in the DB INSERT logic?
-b