Hi I copied this from Microsoft.
40. How do I remove Replication?
If you are just starting out and haven't made many changes to your data and objects, chances are that you created a backup copy of your original database. Search for it in the folder where the replicated database is—it will have the same base file name as the replicated database with a "BAK" extension. If you've gone beyond that point, you need to follow these steps:
1. Create a new database and import all the objects from the replicated database, except tables.
2. Close the new database and open the replicated database. Create a new query and select the first table in the Show Table dialog box. Add all the fields except for the replication fields (s_Generation, s_Guid, s_Lineage, s_ColLineage), unless they are used in your application. If so, then add them.
3. Select the Make Table query option and use the current database name and the database name of the database that you just created in step 1. Run the query. Repeat this process for every table in the database.
4. Re-create all indexes, properties, and relationships that existed in the original replicated database.
5. When you've completed the steps above for all tables, make sure to compact and repair the new database.
If you would like to avoid the overhead of having to re-create all of the properties and indexes on your tables, and you don’t mind having the s_Guid field but would like the other fields to be removed, you can do the following:
1. Either delete all of the relationships in your database or make them unenforced. You must perform this step because the Jet database engine will not allow you to have a relationship that enforces referential integrity between a replicated table and a local one.
2. Right-click each replicated table, click Properties, and then click to clear the Replicated check box.
3. Import the tables from the replicated database as you did the other objects.
4. Re-create the relationships in your database (or change their type back to enforce referential integrity). All of the properties (such as InputMask, Format, Caption, and so on) and all of the indexes will still be there.
For an additional method of un-replicating an Access 2000 (Jet 4.0) database, please see the "Additional References and Resources" section at the conclusion of this document.
Additional References and Resources
Trigeminal Software’s website at
contains many replication resources. Trigeminal provides several free Jet replication tools and utilities, including the TSI Access 2000 Un-Replicator, the TSI Synchronizer, and TSO System Fields Removal Utility. Many of these utilities exist in Jet 4.0 and Jet 3.5 versions.
