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

Posted on 2007-07-31
Medium Priority
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
  • 2
LVL 13

Expert Comment

ID: 19600330
Create a replica.

Tools-Replication-Create Replica
LVL 85
ID: 19600335
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 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1500 total points
ID: 19600369
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

ID: 20963929
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

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
LinkedIn blogging is great for networking, building up an audience, and expanding your influence as well. However, if you want to achieve these results, you need to work really hard to make your post worth liking and sharing. Here are 4 tips that ca…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

807 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