Morning All,
We have an intermittent issue, which are always fun.
DB is split with the back end residing on a shared network resource.
We have our main table, which records are entered and then updated by users at different operations.
The main table has an auto number field which is normally set as the PK. I've had to reset this as the PK numerous times in the past.
For some reason, when the user was updating some fields in the record, the record changed all fields to #deleted and dropped the PK from the table.
I have now changed the PK field to another field that is our job number field,
I've done a compact and repair and received 2 errors:
MSysCompactError MSysCompactError
Incidentally, the customer field which is linked to another table and is a required field did not say deleted, but was simply blank.
I should add that certain fields, such as customer, are not editable in the view the users use when updating the records, and the fields they can change are not mandatory.
Any ideas where I could start looking at what is causing this issue? It seems
We have an intermittent issue, which are always fun.
DB is split with the back end residing on a shared network resource.
We have our main table, which records are entered and then updated by users at different operations.
The main table has an auto number field which is normally set as the PK. I've had to reset this as the PK numerous times in the past.
For some reason, when the user was updating some fields in the record, the record changed all fields to #deleted and dropped the PK from the table.
I have now changed the PK field to another field that is our job number field,
I've done a compact and repair and received 2 errors:
MSysCompactError MSysCompactError
ErrorCode | ErrorDescription | ErrorRecid | ErrorTable |
---|---|---|---|
-1017 | Record is deleted. | | Job Register and Report Log |
-1053 | Index or primary key cannot contain a Null value. | | Job Register and Report Log |
I should add that certain fields, such as customer, are not editable in the view the users use when updating the records, and the fields they can change are not mandatory.
Any ideas where I could start looking at what is causing this issue? It seems