Re: Data storage "delay"

We have a problem. Simple explanation: We have two processes, P1 and P2.
P1
stores data to an Access file using ADODB:: objects. Standard stuff,
really.
If data is stored with P1 and accessed again in P1, the data seems to have
been stored properly. However, if the data is accessed in P2 just after
the
storage in P1, the data is NOT in the accessfile. If we put in a
Sleep(2000)
in P2 just before the access to the data, the data IS available. What is
happening here??

It is part of Jet latency. Any AddNew's take time before they really migrate
to the database on a per-process basis. That explains what you are seeing.

Have a look here which explains the problem
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q200300

Stephen Howe


.