how to remove little replication icons

[dxp]

Hi everyone, does anyone know how to remove the little replication icons next to the db objects when a replica is converted back to a design master. I know there is a way cos i've seen it here before but I can't find it searching. Thanks.

 

[Dreamweaver]

Go Here

http://www.trigeminal.com/utility.asp?1033

I converted a replica using the TSI Access 2000 Un-Replicator Then I had to use the TSI Replication System Fields Utility This worked on a 2003 but make sure you do a good backup

 

[dfenton]

Hi everyone, does anyone know how to remove the little replication icons next to the db objects when a replica is converted back to a design master. I know there is a way cos i've seen it here before but I can't find it searching. Thanks.

Your question doesn't quite make sense. If you've promoted a replica to be a Design Master, then it's still replicated, and there's nothing you can do to get rid of the icons that indicate that the tables are replicated, other than to right click on them in the DM and in the properties uncheck REPLICABLE.

If all you mean is to unreplicate, then that's the way to do it, unless you want to use one of the tools available to help you unreplicate:

* Access 2002 instructions (should work for A2003, too)
http://support.microsoft.com/kb/290052/

* Access 2000 instructions
http://support.microsoft.com/kb/208394/

* Access 97 instructions
http://support.microsoft.com/kb/153526/

The A97 article also has a download link for the Jet 3.5 unreplication wizard:
http://support.microsoft.com/kb/168398/

There are two other tools that also work for Jet 4 databases:

* Michael Kaplan's TSI Un-Replicator Add-in
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=7#7

* Graham Search's Unreplicate Utility
http://www.pacificdb.com.au/MVP/Code/UnReplicate.htm

The latter has code, and you could perhaps learn something by reviewing the code, but I've never actually used the latter (I've hardly ever unreplicated anything).

--
David W. Fenton
David Fenton Associates
http://dfenton.com/DFA/