A REPLICA is probably what you need in this situation. For everyone else, a REPLICA is when you make a copy of your Access database that you can take on the road with you, or send to a different location that doesn't have Internet access. Any changes made to the Replica can then be merged back into the main database when you are able to bring them together (copy on a CD, for example). If you're out on a ship and you need access to the database, you can use a Replica, and then when you're back to shore, synchronize the two together. Unfortunately, this is not an easy process, and I don't have a tutorial available for it YET. I will be covering it eventually, but in my mountains of Access tutorials, I don't have anything for Replication as of right now. If this is urgent for you (and if anyone out there reading this wants to learn how to do this too), let me know and perhaps I can throw together a quick mini-lesson in how to do it. I've used Replicas before. I made a database that was designed for sales agents "in the field" to carry on their laptops. They would enter sales and contact info, and then at the end of the week when they went back to the office, merge them all together. The problem is that resolving conflicts is NOT always easy. If you change JOE SMITH and I change JOE SMITH and then we try to merge them, someone's data goes bye-bye.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.