Safely removing replication from Access 2003 db.

[Guest]

The short Questions:
1) How do I safely remove replication from a copy of an MS Access 2003
database? Safely as in without affecting any of the other replicated copies?
2) How can I find all the copies of this database still being replicated to
after the design master has been lost?

The long Questions:
Hello All, I’m new to Access replication and have started at a company that
uses several Access databases with replication. We are creating a new site
using a similar database structure. I’ve made a copy and would like to start
by removing replication both because it is not necessary in our environment.
Also I’m about to make some database changes and am worried they changes or
record deletions will be propagated. As mentioned I do not believe there is
any reason to use replication for this project so I would like to remove it
for all databases, unfortunately several of the databases are very critical
so I want to be as informed as I can before making any changes since if I
break it and do not know enough to fix it my company would loose a lot of
money. Is there anyway from a given database (besides the replication master,
it has been long lost) to find all the databases that are replicated?

Lastly before undertaking this project is there any advice anyone here can
give me to better my chances of success? Any lessons learned?
-Brian Sky

 

[Guest]

I should have probably said before I have downloaded and read “replfaq2k.exeâ€
it unfortunately could not clarify my confusion about removing replication.
My other searches of this forum only turned up a tool to remove replication
from Access 97 databases, no mention if they would work with 2003.

I’m being careful as this is an important set of databases in our company.

 

[Guest]

I tried using the "SysFld40.exe" that I downloaded from
"http://www.trigeminal.com/lang/1033/utility.asp?ItemID=11#11" that is
supposed to remove replication but all I get is a dialog box that tells me to
fill in the database name but nowhere to fill it in?????
I really would like some way to get rid of the replicated fields.

 

[Joan Wild]

You should ask in the replication newsgroup.
http://www.microsoft.com/communitie...5e-4fa9-83fd-74fb8dd5c8ca&lang=en&cr=us--Joan WildMicrosoft Access MVPMAT4Ron wrote:> I tried using the "SysFld40.exe" that I downloaded from> "http://www.trigeminal.com/lang/1033/utility.asp?ItemID=11#11" that is> supposed to remove replication but all I get is a dialog box that> tells me to fill in the database name but nowhere to fill it in?????> I really would like some way to get rid of the replicated fields.> --> Proud To Serve In The US Military>>> "BrianSky" wrote:>>> I should have probably said before I have downloaded and read>> "replfaq2k.exe" it unfortunately could not clarify my confusion>> about removing replication. My other searches of this forum only>> turned up a tool to remove replication from Access 97 databases, no>> mention if they would work with 2003.>>>> I'm being careful as this is an important set of databases in our>> company.