How to sync database when you have a copy outside the office?

Posted on 2007-07-31
Last Modified: 2013-11-24
Have a data sharing program designed for mortgage brokerage.  All agents share a single database.  Sometimes I'd like to be able to take my laptop out in the field and work with clients.  I know I can carry a copy of the database with me (not an option to remote in to the network) but how can I sync with the "mother" database once I return?  I may have made changes to the database as well as the others here at work.
Question by:JayMulkey
    LVL 13

    Expert Comment

    Create a replica.

    Tools-Replication-Create Replica
    LVL 84
    What version of Access are you using? In 2003 or earlier, Access supports "replication", which basically does exactly what you're asking.

    You can also build your own replication scheme, but it can get VERY complex ... and if you must consider your changes along with other users changes, then you'd inevitably run into Conflicts ... i.e. where you and another user may have changed the same record. If that occurs, then who "wins"? While it's possible to build replication engines, in general you're better off letting Access do the work for you.

    The Replication FAQ:
    LVL 84

    Accepted Solution

    It's not as simple as creating a replica IF other users must also enter data into this application. If you are going to replicate, then ALL users must also replicate (otherwise their changes won't be migrated to your database, and yours won't go to theirs).

    Also, I should have mentioned that replication brings with it some performance issues, and is not without problems, and causes more maintenance chores. Before going down this road, please readup on Replication in the FAQ and by searching for and reading up about the task (including newsgroup readings on the subject, which are very informative).
    LVL 11

    Expert Comment

    No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

    I will leave the following recommendation for this question in the Cleanup Zone:
    Accept [LSMConsulting]'s comment as answer.

    Any objections should be posted here in the next 4 days. After that time, the question will be closed.

    Experts Exchange Cleanup Volunteer

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Even if you have implemented a Mobile Device Management solution company wide, it is a good idea to make sure you are taking into account all of the major risks to your electronic protected health information (ePHI).
    Join Greg Farro and Ethan Banks from Packet Pushers ( and Greg Ross from Paessler ( for a discussion about smart network …
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    After creating this article (, I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now