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 dennisbv
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
by dennisbv
by dennisbv
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending