🚀 go-pugleaf

Hi all!

I've tried to write two clients that access the same database (MS Access
2000) via OLEDB driver for Microsoft Jet 4.0, the problem is that the
EOLEException ( ' The especified row could not be located for updating.Some
values may hace been changed since it was last read ' ) occured when each
application tried to write different data in the same record NOT
SIMULTANEOUSLY.
Here are the main code of both clients:

Client 1
...
void __fastcall TForm1::Button1Click(TObject *Sender)
{                                                                                       
    ADODataSet1->Refresh();                                            
    ADODataSet1->Edit();                                                  
    ADODataSet1->FieldValues["FIELD1"] = 1;
    ADODataSet1->Post();
}

Client 2
...
void __fastcall TForm2::Button1Click(TObject *Sender)   
{                                                                                       
    ADODataSet1->Refresh();                                            
    ADODataSet1->Edit();                                                  
    ADODataSet1->FieldValues["FIELD1"] = 2;
    ADODataSet1->Post();
}

How can any clients write data to the same database correctly? Should I consider some settings to my ADOConnection that I have ignored?

Note: When only one client writes to the database and the other reads there wasn't any problem.

Thanks all