Note The information in this topic applies only to a Microsoft Access database (.mdb).
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
- 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.
- If your database employs a database password to help protect it, remove the password.
- On the Tools menu, point to Replication, and then click Create Replica.
- Click Yes when you are asked whether you want to close the database.
- 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 (Design Master: The only member of the replica set in which you can make changes to the database structure that can be propagated to other replicas.) before the first replica is created).
- 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 (visibility: A property of a replica that indicates which members of the replica set it can synchronize with and which conflict resolution rules apply. Replicas fall into three visibility types: global, local, and anonymous.) 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