DAO recordset thread safe exception

  • Thread starter Thread starter KeanHeng
  • Start date Start date
K

KeanHeng

Guest
Guys....

I'm using this as per below, but it is not helping.

AfxDaoInit();
AfxDaoTerm();

1. I have two Processes, first process writing into same database (I have no control since it's company library).

Second process, what I am doing is to just to read same data from same database using DAO recordset.


2. As I understand, DAO recordset is not thread safe, but I really need this to be done.

3. To a certain extent, sleep xxx seconds before read from database do help.

4. But s/w will crash silently, when both processes trying write-read at same time. :(

Faulting module name: dao360.dll, version: 3.60.9765.0, time stamp: 0x4dff9cc8
Exception code: 0xc0000005
Fault offset: 0x00069df6
Faulting process id: 0x2134
Faulting application start time: 0x01d4e51287a95fea
Faulting module path: C:\Program Files (x86)\Common Files\Microsoft Shared\DAO\dao360.dll
Report Id: a43ee75b-eebf-4366-ba8e-c4c332510ff2

Continue reading...
 
Back
Top