Previous Thread

7/25/2006 1:31:48 PM    How to make a replica not a replica
Hi, 
 
Anyone know how to do this?  Short of manually editing every database 
 
object to make it not replicable?  I have inherited a database that was 
 
using replication for no reason, a simple split design with the back 
 
end on a file server will work fine.  So I want retain all the objects, 
 
but get rid of replication fields in tables, and hopefully whatever 
 
indexing and path info was being used to support replication.  Any 
 
suggestions? 
 
Thanks



7/25/2006 1:37:14 PM    Re: How to make a replica not a replica
Oh, looks like just creating a new database and importing all objects 
 
will work, so I guess anyone had any trouble doing this? 
 
J.D. wrote:

7/25/2006 6:25:05 PM    Re: How to make a replica not a replica
"J.D." <jhowell@courts.state.ny.us> wrote in 
 
news:1153859834.095815.204600@i3g2000cwc.googlegroups.com: 
 
Well, the replication fields stay in the tables, and cannot be 
 
deleted. 
 
Search this newsgroup on Google Groups for "unreplicate" and you'll 
 
find links to utilities that will do it for you. 
 
-- 
 
David W. Fenton                  http://www.dfenton.com/ 
 
usenet at dfenton dot com    http://www.dfenton.com/DFA/

7/26/2006 12:30:03 AM    Re: How to make a replica not a replica
Here is a utility that can unreplicate a database: 
 
http://www.pacificdb.com.au/MVP/Code/UnReplicate.htm 
 
On 25 Jul 2006 13:31:48 -0700, "J.D." <jhowell@courts.state.ny.us> 
 
wrote: 
 
-- 
 
jackmacMACdonald@telusTELUS.net 
 
remove uppercase letters for true email 
 
http://www.geocities.com/jacksonmacd/ for info on MS Access security