by "SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." <microbrain@[EMAIL PROTECTED]
May 8, 2008 at 07:26 PM
Dear Sir,
I am using Access 2000 with VB6, ADO 2.5 & Microsoft.Jet.OLEDB.4.0 in my
application.
In my application all Inserting / Deleting & Updating process is within
BeginTransaction & Commit Transaction.
All tables of database is having primary key & required other indexes.
All tables of database is related with parent table and enforce
referential
integrity.
I am using INSERT, UPDATE, DELETE Query to manipulate data.
I am not binding recordset with any control.
Then also in multi-user environment my data gets corrupted in some of
Local
Area Network when any of machine is having problem or hangs while saving.
Can any one explain me why this ?
Thanks in advance for sup****t.
Sanjay Shah