Microsoft KB Archive/153526

= ACC: How to Make a Replicated Database a Regular Database =

Article ID: 153526

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q153526



SUMMARY
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 ACC95: Access 7.0 Replica to Regular DB Wizard Available in Download Center

168398 ACC97: Access 97 Replica to Regular DB Wizard Available in Download Center



MORE INFORMATION
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.

