Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Synchronization (Access 2000)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Synchronization (Access 2000)

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

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Synchronization (Access 2000)

    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

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Synchronization (Access 2000)

    Basic answer: Tools | Replication | Create Replica...

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

    Access moderator <!profile=WendellB>WendellB<!/profile> 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.

  5. #5
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Synchronization (Access 2000)

    Thanks Hans. I'll start reading!!!

    Leesha

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •