A Replicated Access database is reporting synchronisation conflicts that do't appear to exist.
The Conflict resolution box appears showning NO tables, but if you click details, it lists two records detailing primary key conflicts in "Site Table". Investigation of the table shows no problems.
The file MSYS_Errors contains these error records - it is owned by "Engine", and nothing we have tried will let us delete these records to clear the conflict error, which now totally halts synchronisation.
The table "Site Table" has no matching "Site Table_Conflict" table, as havae other table that have had genuine conflicts.
This may all be due to a power cut half way through a synchronisation.
How do we clear the error records? Even the system administrator cannot access this data.
Any help greatly appreciated - as the system is now "down".
Regards, rob@trainease.com
The Conflict resolution box appears showning NO tables, but if you click details, it lists two records detailing primary key conflicts in "Site Table". Investigation of the table shows no problems.
The file MSYS_Errors contains these error records - it is owned by "Engine", and nothing we have tried will let us delete these records to clear the conflict error, which now totally halts synchronisation.
The table "Site Table" has no matching "Site Table_Conflict" table, as havae other table that have had genuine conflicts.
This may all be due to a power cut half way through a synchronisation.
How do we clear the error records? Even the system administrator cannot access this data.
Any help greatly appreciated - as the system is now "down".
Regards, rob@trainease.com