Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jun 2001
    Location
    Bethlehem, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Replication of a split database (Access 2002)

    I have currently a database on a network drive that I share with my coworker. I split the database into a frontend that resides on my local drive and the backend that resides on the network drive. This works well while I am connected to the network but I need to access the database while offline. I am looking into replication as a solution to my problem. I am very new to replication and need some assistance.

    What database do I replicate frontend or backend? In a test database, I tried to replicate the backend. When asked for the location of the replica, I entered a folder on my desktop. However, when I was offline I couldn't connect to the backend. What am I doing wrong.?

    Any help would be appreciated

    Thanks in advance

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Replication of a split database (Access 2002)

    If you have really split the database so that there are no tables in the front-end that get updated on a regular basis, then all you need to replicate is the back-end. Replication of front-ends can be done, but our experience with it has been less than happy. So replicate just the back-end, leaving the Design Master on the network drive, and create a replica on your local hard-drive. You could have two copies of the front-end that connect one to the Design Master and the other to your local replica, or you could use the Linked Table Manager to switch a single front-end back and forth. A couple of other suggestions - set up a schedule where you synchronize regularly and frequently, and also create a second replica, preferably on a second network drive that is also always synchronized. The latter is just in case the drive where the Design Master resides crashes hard - backups of replicated databases are of very little value.

    Finally, let me suggest check out this link to our Replication Tutorial - it contains some links to other resources, and will give you an idea of some of the downsides of replication.
    Wendell

  3. #3
    Star Lounger
    Join Date
    Jun 2001
    Location
    Bethlehem, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replication of a split database (Access 2002)

    Wendell,

    Thank you for your quick response. I had a feeling that this was the way to go. I just wanted to hear it from the experts.

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

Posting Permissions

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