RE: Simple replication situation/question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Brian (Brian_at_discussions.microsoft.com)
Date: 12/23/04

  • Next message: Jack MacDonald: "Re: Simple replication situation/question" 
    Date: Thu, 23 Dec 2004 06:37:02 -0800

    Gary,

    Not sure if you solved your problem, but here is a suggestion. The solution
    is quite simple. We have used the method below hundreds of times to share
    data amoung teams of 10 to 20 people collecting and analyzing data.

    1. separate your data from the forms and reports (front end-back end approach)

    2. Make a replica of the data

    3. Create a new sub folder - suggest that you name it "Sync" and place a
    COPY of the replica in the subfolder

    4. Synchronize your data file with the .mdb file in the "Sync" subfolder,
    then attach the "Sync" file to an email and send to your friend.

    5. Have your friend save the email attachment to a "Sync" folder.

    6. Your friend will need to use a COPY of the replica as the data file for
    with his front end forms and reports mdb (i.e., the files must come from the
    same replica set.

    7. After your friend adds data to the file, he or she should synchronize to
    the replica in the "Sync" folder, then email the sync folder file back to you
    as an attachment.

    8 You will need to save the attachment in your "Sync" folder (over writing
    your existing file), then synchronize with your data file.

    9. Repeat as necessary to keep your two databases synchronized.

    This sounds like a lot of steps, but once you get the pattern, it is quite
    simple. We have constructed vba code to automate the process.

    I hope this helps

    "Gary Schuldt" wrote:

    > I am about to make my first attempt at replication.
    >
    > I have an Access 2K hobby database on garden plants I wish to share with a
    > fellow gardener (user B). Our connection is either via email or exchange of
    > CD's. We both wish to be able to update it without waiting for the other to
    > return a "single copy", and we are willing to use email frequently (every
    > day or two) to resync them.
    >
    > If I replicate the master such that the replica also resides on my computer
    > (the one with the master, different folder), can I email the replica to user
    > B, have them email it back to me with updates, put it in the same place it
    > originally resided (same name, same folder, same computer), and resync it
    > with the master?
    >
    > I have read several of the articles on replication and am not a novice in
    > Access, but I haven't yet seen a clear answer to my question.
    >
    > TIA,
    >
    > Gary
    >
    >
    >

  • Next message: Jack MacDonald: "Re: Simple replication situation/question"

    Relevant Pages