I agree, except for a couple of things. Syncing is meant for having two databases the same, taking one offsite, adding to the database, etc. then syncing. Even adding a patient would be based on the current database. In Mory's situation, he has been adding patients to each and therefore there are patients with the same ID#s. Syncing those would probably result data loss or corruption.
Mory, no matter how many AC databases you have, the computer will know because the clients will decide where to connect. You do that manually. Your backups will be the same way. They will backup where the backup is pointed.
I have always had questions about how to install, as I like my program on the C: drive and my database on my D: drive. This means installing to the C: drive and moving SQL databases to D: which is not all that difficult.
I think I can fix your problem, but I would like to take it to a PM.
John's idea is a good idea and may even work, but even under the best of circumstances, I don't trust sync either, especially in this situation.
