G
Guest
One of our program which is in all the computers( having different operating
system ) has accdb file as backend database. Multiple operations such as
saving, deleting, adding etc. are done simoultaneously. During this the
database gets corrupted periodically resulting in unrecodnised database
format error or records having #ERROR and loss of data. If we compact and
repair the database we loose the precious data.
The product is developed using microsoft visual basic 6.0 and our
development team put in regorous effort in finding out the cause to the
problem and hence came out with certain solutions such as closing the
connection, having a primary key etc which didn't help much in solving the
problem and our hardware team has examined the network and found no problem.
Please let us know how to avoid this problem occuring time to time.
system ) has accdb file as backend database. Multiple operations such as
saving, deleting, adding etc. are done simoultaneously. During this the
database gets corrupted periodically resulting in unrecodnised database
format error or records having #ERROR and loss of data. If we compact and
repair the database we loose the precious data.
The product is developed using microsoft visual basic 6.0 and our
development team put in regorous effort in finding out the cause to the
problem and hence came out with certain solutions such as closing the
connection, having a primary key etc which didn't help much in solving the
problem and our hardware team has examined the network and found no problem.
Please let us know how to avoid this problem occuring time to time.