Article ID: 208394 - Last Review: June 24, 2004 - Revision: 2.1

ACC2000: How to Make a Replicated Database a Regular Database

View products that this article applies to.
This article was previously published under Q208394
Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies only to a Microsoft Access database (.mdb).

For a Microsoft Access 2002 version of this article, see 290052  (http://support.microsoft.com/kb/290052/EN-US/ ) .
Expand all | Collapse all

SUMMARY

This article shows you how to convert a replicated database back to a regular database.
Back to the top

MORE INFORMATION

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:
  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. Under Objects click Queries, 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 (Gen_OLE Fieldnames, s_ColLineage, 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. Re-create all indexes and relationships that existed in the replicated database.
  8. After you've completed steps 1 through 7, 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.
Back to the top

REFERENCES

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
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Back to the top
Keywords: 
kbhowto KB208394
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations