 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Replication / September 2003Urgent Replication Question
I have a database on our network. I have run replication on it creating a Design Master and 3 additional replicas located in the same network file. I will be keeping the Design Master on the Network and will do my syncronizing there. My question is.... would there be a problem with me connecting to the laptops and dragging a copy of each replica to each laptop from the network location? And after the updates are made dragging the updated replicas back to the network location from the laptops and proceed to synch with the Design Master using these replicas that were overwritten with the laptop updates? The replicas won't lose their replication status by doing this? I searched everywhere regarding this and couldn't find anything. I would appreciate anyone guidance or suggestions. Thanks a bunch, Kim do not do that.....here's why http://www.trigeminal.com/usenet/usenet009.asp?1033 > I have a database on our network. I have run replication > on it creating a Design Master and 3 additional replicas [quoted text clipped - 15 lines] > anything. I would appreciate anyone guidance or > suggestions. Thanks a bunch, Kim So, if the Replication Manager or the briefcase reconciler is not used, there is no other way to place the replicas on the laptops? >-----Original Message----- >do not do that.....here's why [quoted text clipped - 22 lines] > >. I thought that if you move/copy/namechange the 'Design Master' it will lose it's replication. I've tested the replicas and they seem to sync up, but I may be missing something. >-----Original Message----- > [quoted text clipped - 33 lines] >> >. You can distribute new copies of a replica set to other locations if the newly created replica is never opened or accessed in any way until it is at the intended install location. > So, if the Replication Manager or the briefcase reconciler > is not used, there is no other way to place the replicas [quoted text clipped - 29 lines] > > > >. Would pathing out the location directly to the laptops (from the network) when creating the initial replicas work? When synching is done, could I synch directly from the laptops to the Design Master on the network? There wouldn't be any moving/copying done. >-----Original Message----- >You can distribute new copies of a replica set to other locations if the [quoted text clipped - 36 lines] > >. What's wrong with Tools/Replication/Create Replica ? Do it from Access and you get 1000 days between synchs if you need it.... The design master should not be part of your replication topology. Use it for design changes to the replica set only. > Would pathing out the location directly to the laptops > (from the network) when creating the initial replicas [quoted text clipped - 51 lines] > > > >. Nothing, that is how I create replicas in Access ... but when it prompts you as to the location at where you would like to put the replica(s) (not the design master), would putting it directly on a laptop be wise? And would synching from there be ok? Do my questions make any sense? Sometimes it hard for me to explain myself. So, are you saying that if I need to add a record/or change data to a table don't do it using the design master? That is should only be used for design changes only? >-----Original Message----- >What's wrong with Tools/Replication/Create Replica ? [quoted text clipped - 61 lines] > >. Presuming that your laptops connect to the same LAN - that is precisely how you would create the replicas - or you use Replication Manager - which I presume that you have - to move the replicas you have already created and thereby properly retain their identity and location. The whole purpose of replication is to allow you to have multiple copies of the same database - 1 synchoronization away from being identical. To synchronize, they need to be occasionally connected via RAS, LAN, WAN or the Internet to be able to synchronize their data. The purpose of the design master is to allow changes to be made in the design of tables and queries, which changes can then be propagated to other members of the replica set - also by synchronization. You need to get a good grasp of replication concepts and pitfalls by reading the documentation/white papers available from Microsoft and other Access sites - like Trigeminal's - so that you have a good handle on where you are going with your replication plans and what you can expect as a result. > Nothing, that is how I create replicas in Access ... but > when it prompts you as to the location at where you would [quoted text clipped - 88 lines] > > > >. That was the one step I couldn't find in all that I've read on the subject, creating the replica directly to the laptop(s) (I don't have Replication Manager). I unfortunately created the replicas, the wrong way (a week ago), for the laptops on the network and dragged the replica files over to the laptop (after connecting them via network cable). They are now being used and I have to now figure out how to get the data from the laptops without screwing everything up. Any suggestions? Anyways, thanks for that one thing I've been searching for. This is my very first attempt at creating an ACCESS application. >-----Original Message----- >Presuming that your laptops connect to the same LAN - that is precisely how [quoted text clipped - 109 lines] > >. If these replicas were *not* opened in any way before they reached their final destination then they should be Ok. FWIW, I'd recommend that you start looking at Replication Manager and indirect synchronization soon, as this is a very much safer way of synch-ing than direct. Tom Trosborg. > That was the one step I couldn't find in all that I've > read on the subject, creating the replica directly to the [quoted text clipped - 153 lines] > > > >. Please note that "ever opened" in this context is NOT "ever opened by Access in the UI", its "ever opened by Jet in ANY WAY whatsoever". But if the goal is to get the data, unreplicate, and start over -- then its better to just do it. Its already to late to avoid the illegal move/copy since it has been done. So just cooy it back, get the data out, and start over.  SignatureMichKa [MS] This posting is provided "AS IS" with no warranties, and confers no rights. > If these replicas were *not* opened in any way before they reached their > final destination then they should be Ok. [quoted text clipped - 162 lines] > > > > > >. |
Reply to this Message |
 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.