Access 2007 Programming by Example with VBA, XML, and ASP

Chapter 18Database Replication

To make your database available to users in various geographical locations, you can provide them with a full or partial copy of the database. Mobile or remote users can maintain a local copy of a database, make changes to data offline, and synchronize with the main database on a regular basis. All this can be achieved via the technology known as database replication. When you replicate a database you simply create multiple copies (replicas) of your application and distribute them to users in remote locations so that they can easily share the changes they are making to a database. Database replication also offers other advantages, such as:

Convenient distribution of updates to existing applications — Changes made ...