Corrupted conflict errors in Access Replication

[TrainEase]

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

 

[DougP]

First make a copy of the database in explorer. So if any of the following make it worse then you have the original.

Try Repairing it. Open Access then click 'Tools' menu then 'Database Utilities' then 'Repair Database'

if that does not work then delete it and create another copy then...

Try importing the tables into a new database

Create a new database and them right click in the white space.
Click Import and them find your corrupted database.
Try bringing in one table at a time.
If you cannot import one of them you will know which table has a problem.


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.