05-03-2010 01:05 PM
Here is my situation.
I have a parent database that contains 51,446 records and several remote databases, that even after synchronization, only contain 51,410 records. I am missing 36 records.
I have checked for "private" records in the parent database - there are none.
Any advice on best practice to right this anomaly?
I am thinking first, give a unused user field in the remote database an arbitrary name such as "missingrecords." Then sync with parent. This will isolate the missing 36 records.
Then create a shell database with no records and export the missing records to the shell.
Then move the shell databases with the new records over to a remote and import them. Then sync again.
Do you think this will get my record count the same on all computers?