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 support.
Sanjay Shah
Alex Dybenko - 09 May 2008 07:43 GMT
Hi,
could be that this is network issue, look here for more info:
http://www.granite.ab.ca/access/corruptmdbs.htm

Signature
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
> Dear Sir,
>
[quoted text clipped - 22 lines]
>
> Sanjay Shah