NOTE: When you follow the steps in this article, the following
settings 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:
Create a new database.
Import all the objects, except for the tables, from the
replicated database into the newly created database.
Close the new database, and then open the replicated
database.
In the Database window, click Queries under Objects, and then click New.
In the New Query dialog box, click Design View, and then click OK.
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
(Gen_OLE Fieldnames, s_ColLineage, s_Generation,
s_Guid, s_Lineage). If your application requires one of these fields that was
created by replication, go ahead and add it to the query.
On the Query menu, click Make Table. In the Table Name box, select the current table name. Click Another Database, and add the name of the database that you created in step 1. Run
the query.
Repeat steps 4 through 7 for each table in the replicated
database.
Close the replicated database, and then open the new
database. Re-create all indexes and relationships that existed in the
replicated database.
After you've completed steps 1 through 9, compact and then
repair 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 aregular database,
click Microsoft Access Help on the Help menu, type make a replicated database a regular database in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Back to the top
