ACC: How to Make a Replicated Database a Regular Database

Advanced: Requires expert coding, interoperability, and multiuser skills.

This article demonstrates how to convert a replicated database back to a regular database.

NOTE: There are also two wizards available on Microsoft's World Wide Web site that will convert a replicated database for you. These are add-ins for Microsoft Access that enable you to convert the Design Master database from a replica set back to a regular database.

For more information about how to download these files, please see the following articles in the Microsoft Knowledge Base:

162861  (http://support.microsoft.com/kb/162861/EN-US/ ) ACC95: Access 7.0 Replica to Regular DB Wizard Available in Download Center

168398  (http://support.microsoft.com/kb/168398/EN-US/ ) ACC97: Access 97 Replica to Regular DB Wizard Available in Download Center

NOTE: When you follow the steps in this article, the settings below will not automatically convert to the regular database:

• Non-default references
• Security of the database objects
• Table indexes
• Table properties
• Validation rules

To convert a replicated database back to a regular database, follow these steps:

1. Create a new database.
2. Import all the objects, except for the tables, from the replicated database into the newly created database.
3. Close the new database, and then open the replicated database.
4. Click the Queries tab, and then New, and create a new query in Design view. Select the first table in the Show Table dialog box. Drag all the fields to the Field row, except for the fields that were generated for replication (s_Generation, s_Guid, s_Lineage). If your application requires one of these fields created by replication, then go ahead and add it to the query.
5. On the Query menu, click Make Table. In the Table Name box, select the current table name. Click to select Another Database, and add the name of the database that you created in step 1. Run the query.
6. Repeat steps 4 and 5 for each table in the replicated database.
7. Close the replicated database and open the new database. Recreate all indexes and relationships that existed in the replicated database.
8. After you've completed steps 1 through 7, compact the new database. The new database should be approximately the same size as before replication and will not contain any replication properties.

For more information about converting a replicated database back to a regular database, search the Help Index for "nonreplicated databases," or ask the Microsoft Access 97 Office Assistant.