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 / February 2006

Tip: Looking for answers? Try searching our database.

Add New Table To Replicated Database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
icclearly@mindspring.com - 12 Feb 2006 16:20 GMT
I have several replicated databases running.  Each database has its own
design master, hub and replicas (some partial and some full).  For the
sake of discussion I'll call each of these unique sets a replica group.
The design master (DM) for each of these groups was created from the
same non-replicated database and they are all identical.

Here's the question.  I want to add a new table and add a couple of
fields to an existing table to each of the DMs and have them replicated
down to the replicas.  I need to know the best way to accomplish this.
Is it possible to make the changes in the original non-replicated db
and then create a new design master from this non-replicated db and do
a one-way sync from this new DM to the DM of each replica group?  Or,
will I need to manually make the changes?  If it is the latter, I can
modify each of the fields but must programmatically add the new table
because the DM will not allow me to add a new replicated table.

Any suggestions would be appreciated.

Thanks.

IC
David W. Fenton - 12 Feb 2006 20:10 GMT
> I have several replicated databases running.  Each database has
> its own design master, hub and replicas (some partial and some
[quoted text clipped - 14 lines]
> but must programmatically add the new table because the DM will
> not allow me to add a new replicated table.

No. Once the design masters are created and there are replicas, you
have to make the changes to the different design masters.

Each replica set knows nothing of the others, even though they are
identical.

You will have to add the table/fields in each DM.

I can't quite understand why anyone might think otherwise.

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

 
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



©2008 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.