synchronising two sites

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the same database at two sites. I need to update both sites with the
new records eg: new customer, or updated details.
The original databse uses Autonumber to generate the PK.
I'm thinking of creating a CustomerNumber manually, and I'd then need to
check for duplicate records.
Is this a good way to do this or are there better options?
Thanks,
Alan
 
Alan

This won't help you in your current situation, but consider looking into the
replication newsgroup for future reference.

Another approach might be to add a single field to the table ... Site.
You'll still need a way to handle the fact that each table is keeping its
own Autonumbers, so a CustomerNumber sounds like a good idea.

You'll still need to have a process for combining the data, since each site
might have a "John Smith".

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Back
Top