Create a replica of your database

Microsoft Replication Manager

Create a replica of your database

  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.

    Important   Before replicating your database, it is recommended that you read about the changes that are made to a database when it's replicated. To read about these changes, click .

  2. If your database is protected by a database password, remove the password.

    How?

  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, select the location where you want to place the new replica.

  7. In the Location of New Replica dialog box, click the Priority button, type the priority for the replica, and click OK. For more information about setting replica priority, click .

  8. In the Location of New Replica dialog box, check the Prevent deletes check box if you do not want users to delete records in the replica.

  9. In the Location of New Replica dialog box, select the replica visibility from the Save as type drop-down list box. For more information about replica visibility, click .

  10. Click OK.

Notes

  • When you replicate a database, all the tables, queries, forms, reports, macros, modules are replicated by default, as well as the data. For more information on how to keep your forms reports, macros, and modules local, click .

  • For other considerations when replicating a Microsoft Access project, click .