Automatic Update

[Guest]

I have two identical databases that I want to combine without having any
duplicates. The user wants to be able to either press a button or be able to
schedule this process to run at a certain time. Or if anyone knows if you
can have this happen electronically where you don't have to have two database
run against each other please provide that information. Hopefully, it's
clear on what I am asking about but, if not please let me know. Thanks in
advance for any help anyone provides.

 

[George Nicholson]

Check out "replication" in the Help files & see if that's what you need.

 

[Guest]

Is the replication process just a copy of the database? If so I need to know
how to run two separate database against each other and get no duplicate
records. Am I understanding replication right? Thanks again.

 

[George Nicholson]

No, replication is not "just" a copy. It is a very sophisticated copy that
contains special info that allows you to synchronize 2 replicas/copies that
were updated independently of each other. Once synchronized, both files
contain each others updated information and are "identical" replicas/copies
again.

Replication Manager comes with the Developers Tools (at least in 2002/XP)
and allows you to schedule the synchroziation to run unattended.

also: http://support.microsoft.com/default.aspx?scid=kb;en-us;282977
Access 2000 Replication FAQ is available in Microsoft Download Center
(I believe FAQs for other Access versions are also available)

You might be better off directing further questions to
Microsoft.Public.Access.Replication.

HTH,