Just got two different error 3167 record is deleted - two different
users of my app - both on the same day. And both of them connect to the
same replica on the server (3 groups of users in 3 physical locations;
these two are in the same location and use the same server replica for
sync)
App is split front end/back end. About 25 laptops using replicated back
ends. They sync via computer control when the program is started and
they are connected to the LAN. Sync is direct.
One user had synced OK on 11/9, next time same day failed with 3218
which seems to be a transient error. Then on Monday 11/12, failed with
a 3167.
In my experience a 3167 is the "kiss of death" and the database is
toast. I have never been able to use compress and repair to make such
repairable. In this case the compress was not successful and I got a
new database db1_damaged.mdb as the result.
Found several _conflict tables but all were empty except for the
MSysSchedule_conflict which had 6 records in it.
Have not yet diagnosed the 2nd database.
I have had replication in place since about June of this year. Only one
other 3167 instance a couple of months back.
Suggestions on how to figure out the cause?
Bob
