Discussion Locked

Sync Access Database

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an Access database. I want to put a copy on a zip disk and I need to know the best way to keep the mobile copy and the one on the server synced to the one on the zip disk. I am aware of Microsofts breifcase but I donot know if that is the best way.

6 replies

by dklippert

Access uses the term "replication".
In the search box of the Office Assistant, type Create a replica of your database.
There is a document available for download at support.microsoft.com.
Type Rplfaq97.exe in the search box.

Also at that location you can type in the Q number to get this article:

How to Make a Database Replicable
Q208774

by bob sellman

While replication will work, it is a real pain to use and requires a lot of planning to set up and use correctly, depending upon how your database is being used.

Based on your question, it sounds like all data input/modification will be made to the zip disk version of the database, while the version on the server will not be used for any data input. If that is the case, then just copy the database file from the zip disk to your server as appropriate.

If my assumption is correct and you want to perform updates through a dial up connection and the database is too large to transmit the entire file, you could include a column in the tables that will have new input or edits. Update the date/time column in affected rows in the zip disk database whenever a row is added or modified. When you want to update the server copy, output the changed/added data and just send that to the server. Then you can use that file as a source to perform updates and additions to the server database. Replication might be worth considering in that case if many records might be edited. If records are only added to the zip database, sending the added records and electronically appending them to the server database is easy.

Replication involves manual work when changes to the same data can occur on multiple computers and it may not be clear (from an automatic standpoint) what is the "correct" data for a particular record.

by dennisbv

I want to be able to make changes to the copy on the server ort on the Zip disk and I want to keep them in sync. So no matter which copy I work on they will stay the same.

This discussion is closed to new replies.