Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Replication / November 2005

Tip: Looking for answers? Try searching our database.

Exclude a table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kon - 03 Nov 2005 11:11 GMT
I want to exclude a table from replication. How can I do this?
Thank you In Advance...
Kon
David W. Fenton - 03 Nov 2005 21:28 GMT
> I want to exclude a table from replication. How can I do this?
> Thank you In Advance...

Open the design master. Right click on the table. In the properties
sheet that pops up, uncheck REPLICABLE. Then synch the design master
with one or more of your replicas. The change will then propagate
through the other files.

However, keep in mind that when you do this, the table is *deleted*
from the replicas, so you need to keep a copy of the data so you can
import it back into the files where you need it.

Signature

David W. Fenton                        http://www.bway.net/~dfenton
dfenton at bway dot net                http://www.bway.net/~dfassoc

kon - 04 Nov 2005 06:49 GMT
Thank you.
Unfortunatelly I want the table not to deleted. But I asume that nothing I
can do about it.

> > I want to exclude a table from replication. How can I do this?
> > Thank you In Advance...
[quoted text clipped - 11 lines]
> David W. Fenton                        http://www.bway.net/~dfenton
> dfenton at bway dot net                http://www.bway.net/~dfassoc
David W. Fenton - 05 Nov 2005 04:57 GMT
>  Unfortunatelly I want the table not to deleted. But I asume that
>  nothing I
> can do about it.

Nope. That's the way it works. I think it should leave the table in
the target replicat, too, and just make it unreplicated, but I
didn't have a say in designing how replication worked.

Signature

David W. Fenton                        http://www.bway.net/~dfenton
dfenton at bway dot net                http://www.bway.net/~dfassoc

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.