When I open my database, I get the following message: (This
member of the replica set has conflicts from synchronizing changes
with other members. Do you want to resolve these conflicts now?)
If I choose the "YES" option, I get the following message: There
was a problem trying to connect to the data source." The error
returned was: 48: error in loading dll
I have tried to repair office. I have tried to compact and repair
database.
I have tried to delete the existing replica's and I get the same
results
even if no other replicas exist. Is there something I am missing?
Tom has given you advice on re-registering everything, which is a
good thing to do.
Bu you say "even if no other replicas exist." That's impossible. The
process of replicating an MDB creates at least the Design Master
(the original MDB) and one replica. If you've deleted one of those,
you're causing yourself real problems.
Once created, replicas need to be left where they are, in the same
location and never deleted or copied or moved. You can move them
with Replication Manager's MoveReplica function (or with the TSI
Synchronizer), but JRO doesn't offer this function (JRO lacks a lot
of features it ought to have).
If you can't get the conflict viewer to work, you can at least view
the conflict tables directly. When there's a conflict, Jet creates a
hidden copy of the table with the conflict and stores the record(s)
that lost in the conflict resolution. The table is the name of the
base table with _Conflicts appended to it. To see that you have to
go into Tools | Options and SHOW HIDDEN OBJECTS (you might as well
SHOW SYSTEM OBJECTS, too). The MSysConflicts table lists the known
conflicts, the exact data of which is stored in the ..._Conflicts
table. MSysSideTables lists the conflict tables.
You can view the data in the conflict table and compare it to the
real record (using the s_GUID field to identify which record is
involved). If the data in the main table is OK, you can just delete
the conflict record. If you need some data from the losing record in
the conflict table, copy it to the winning record in the main table,
and then delete the record in the conflict table.
By doing this, you're manually doing exactly what the conflict
resolution wizard allows you to do. Doing it manually is just not
quite as easy.
