I am having problems with corruption in an Access 2003 database. There are 22,000 records in there and can lose multiple records at once.
I have tried fixing the problem by compact and repair, also have tried creating new database and importing all tables etc into new database.
The latter seems to work, however days later the corruption is back.
The error i am getting is: the affected record(s) are displaying what seems to be Japanese chars and when I try to delete I get the following message - "The Search key was not found in any record. Error Code: 3709" Clicking on help says is a ISAM Seek error.
The set up of the database is as follows: 1 Backend db, several front end dbs updating data in the backend.
Could this be caused by network conditions or is it a purely database issue.
Also could this problem be avoided using SQL Server?
Many thanks for any assistance in this matter.
Regards
Alan
I have tried fixing the problem by compact and repair, also have tried creating new database and importing all tables etc into new database.
The latter seems to work, however days later the corruption is back.
The error i am getting is: the affected record(s) are displaying what seems to be Japanese chars and when I try to delete I get the following message - "The Search key was not found in any record. Error Code: 3709" Clicking on help says is a ISAM Seek error.
The set up of the database is as follows: 1 Backend db, several front end dbs updating data in the backend.
Could this be caused by network conditions or is it a purely database issue.
Also could this problem be avoided using SQL Server?
Many thanks for any assistance in this matter.
Regards
Alan