Microsoft Office 2000/Visual Basic Programmer's Guide

Implementing Database Replication

You can implement Microsoft Jet database replication by using the following:

• Microsoft Access menu commands
  
  
• Briefcase replication in Windows 95, Windows 98, or Windows NT 4.0
  
  
• Microsoft Replication Manager
  
  
• Data Access Objects (DAO) programming
  
  
• Jet Replication Objects (JRO) programming

The first three replication tools provide an easy-to-use visual interface, while the last two enable programmers to build replication directly into their solution's code.

Partial replicas are available only by using the Partial Replica Wizard in Microsoft Access (Tools menu, Replication submenu, Partial Replica Wizard command) or through DAO or JRO programming.

Replication can be used on a variety of computer networks, including Microsoft Windows 95 and Windows 98 peer-to-peer networks, Microsoft Windows NT Server or Workstation version 4.0 or later networks, and Novell NetWare versions 3.x, 4.x and 5.x network servers.

For information about implementing replication in Access, search the Microsoft Access Help index for "replication." The Replication Manager ships in the Microsoft Office 2000 Developer package; for information about using it, see Help after installing Microsoft Office 2000 Developer. For information about using DAO programming to implement replication, see the Microsoft Jet Database Engine Programmer's Guide, Second Edition (Microsoft Press, 1997). For information about using JRO to implement replication, see JROReplication.doc, located in the ODETools\V9\Samples\OPG\Appendixes folder on the Office 2000 Developer CD-ROM.