synchronising two sites

A

Alan.M

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
 
J

Jeff Boyce

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/
 
Top