Create a replicated database

Important

• It is recommended that you keep a backup copy of your original database. The backup copy can be used to create another replica set in emergency situations. However, note that any copy made from the backup copy of the database, or any replica made from a converted backup copy, will not be able to synchronize with the existing members in the original replica set.
• Before replicating your database, it is recommended that you read about the changes that are made to a database when it's replicated. For more information, see the Microsoft Access Help topic "Changes made to your database when you use replication."

Note   Any formatting included in PivotTable and PivotChart views used in tables, queries, views, stored procedures, and functions is not replicated when you set up replication for your database. You can replicate the format of PivotTable and PivotChart views in a form.

Create a replica of your database by using the menu bar

1. Open the database you want to replicate. If you are working in a multiuser environment, make sure that all other users have closed the database.
2. If your database is protected by a database password, remove the password.

   How?

   1. On the File menu, click Open.
   2. Click the arrow to the right of the Open button, click Open Exclusive, and then open the database.
   3. In the Password Required dialog box, type the database password, and then click OK. Passwords are case-sensitive.
   4. On the Tools menu, point to Security, and then click Unset Database Password. This command is only available if a database password was set previously.
   5. In the Unset Database Password dialog box, type your current password.
3. On the Tools menu, point to Replication, and then click Create Replica.
4. Click Yes when you are asked whether you want to close the database.
5. Click either Yes or No (Yes is recommended) when you are asked whether you want to make a backup of the database (this dialog box is displayed only if the database must first be converted to a Design Master before the first replica is created).
6. In the Location of New Replica dialog box, do the following:

   Select the location where you want to place the new replica.

   Click the Priority button, type the priority for the replica, and click OK.

   Check the Prevent deletes check box if you do not want users to delete records in the replica.

   Select the replica visibility from the Save as type box.

Note   When you replicate a database, all the tables, queries, forms, reports, macros, and modules are replicated by default, as well as the data.

Create a replica with Briefcase

1. You must have Briefcase installed on your computer. If Briefcase is installed, you will see a My Briefcase icon on the Microsoft Windows desktop. To install Briefcase on your computer in Windows 2000, right-click anywhere on your desktop, point to New, and click Briefcase.
2. If your database is protected by a database password, remove the password.

   How?

   1. On the File menu, click Open.
   2. Click the arrow to the right of the Open button, click Open Exclusive, and then open the database.
   3. In the Password Required dialog box, type the database password, and then click OK. Passwords are case-sensitive.
   4. On the Tools menu, point to Security, and then click Unset Database Password. This command is only available if a database password was set previously.
   5. In the Unset Database Password dialog box, type your current password.
3. In Windows Explorer, navigate to the Microsoft Access database.
4. Drag the database file to the My Briefcase icon on the Windows desktop. You are given the option to create a backup copy of the original database.