Making a Replicated Database a Regular Database

After you've converted a database to a Design Master, you can't convert it back to a regular database. However, if you no longer want to use replication, you can create a new, regular database that contains all of the objects and data in your replicated database without the additional system fields, tables, and properties associated with replication.

   To make a replicated database a regular database

1   Create and open a new, blank database in Microsoft Access.

2   On the File menu, point to Get External Data, and then click Import.

3   In the Import dialog box, click the replica that contains the objects that you want in the new, regular database, and then click Import.

4   In the Import Objects dialog box, click the objects (except tables) that you want to import into the new database, and then click OK.

5   In the new database, create a query for each table in the replica that takes all the data in the replica and puts it into tables in the new database.

6   For each table in the new database, create the same indexes and relationships that existed in the replica table.

7   Save your new database.

© 1996 Microsoft Corporation. All rights reserved.