Synchronization (Access 2000)

Topic

New Reply

I presently have an Access Database on computers in two different locations which are linked together via a DSL connection. The tables are split. The computers on the off-site computers can look back to the main server however it’s painfully slow and when the DSL gets flakey as it often does, data is lost. I’ve started doing some reading re synchronization however this is new territory and I need guidance.

Thanks!

Leesha

Reply | Quote

Replies

So what is your question? Are you asking how to set it up, whether it will work, or something else?

Reply | Quote

My question is how do I go about setting it up. I assumed it would work if it was listed as an alternative in Access.

Thank you,
Leesha

Reply | Quote

Basic answer: Tools | Replication | Create Replica…

But before you rush off, here are some links you should visit first:

Access moderator WendellB has a good tutorial on replication. You will find a link to his web site in his profile. The tutorials are under Support.

ACC2000: How to Make a Database Replicable provides basic information.

From ACC2000: Jet 4.0 Replication White Papers Available in MSDN Online Library you can download two white papers about replication.

ACC2000: Delete Queries Cause Size of Replicated Database to Grow warns that replication can cause your database to bloat in size.

Reply | Quote

Thanks Hans. I’ll start reading!!!

Leesha

Reply | Quote