I have created a small database which has a problem where every now and then it automatically deletes records.
There are 12 tables in total but only 2 which seem to have the problem.
TABLE 1; NCRFORM Table 2; NCRDETAILS
NCRNO (Number - PK) NCRID (Number - PK)
Date Etc
Etc
The tables are joined between NCRNO and NCRID on a one-to-one basis where all Table 1 and Table 2 where equal
The database itself is stored on a remote server and accessed from individual terminals.
Every now and then, when data is entered, details on Table 2 are automatically deleted and each entry is replaced by a series of #########
An error message is displayed and I then have to Compact and Repair the database to get rid of the problem.
The Compact and repair allows me to delete and then re-establish the record in Table 2 but it also removes the Primary key within Table 2 which then has to be put back in.
Does anyone have any idea what is causing this problem and if there is any permanent cure ?