General questions beginnergirl 28.08.2006 20:46:02 It's probably already out there but I can't see where anyone asks: 1. Does the synchronization process matter in what order you do it? Seems like depending upon the order, I've lost my Master Design. I've become quite the expert at recreating it but I'm tired of doing so. 2. Why, once I have synchronized replicas with the Master design and made new replicas for the users, are their files sizes different? There doesn't appear to be missing data but I'm being asked and I just don't know why.

Re: General questions "David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> 29.08.2006 20:20:05 beginnergirl <beginnergirl[ at ]discussions.microsoft.com> wrote in news:9742539D-9A45-485F-9655-6A5A3864B34C[ at ]microsoft.com: [Quoted Text] > It's probably already out there but I can't see where anyone asks: > > 1. Does the synchronization process matter in what order you do > it? Seems like depending upon the order, I've lost my Master > Design. I've become quite the expert at recreating it but I'm > tired of doing so. Why would you *ever* lose your DM? Makes no sense to me at all. You'd only lose it if you check the box to make the target replica the DM, but why would you do that if you hadn't lost the original DM. Last of all, you shouldn't be synching often with the DM, or using it for production editing. The DM should be kept aside and used for one purpose: making design changes to the data table schema. You need to synch with it every month or so to make sure that it doesn't expire, but you shouldn't have frequent synchs with a DM unless you're in the early development stages where your data schema is still in flux. > 2. Why, once I have synchronized replicas with the Master design > and made new replicas for the users, are their files sizes > different? There doesn't appear to be missing data but I'm being > asked and I just don't know why. If you compact them after the synch (twice if there was a design change during the synch) they should all be the same size. This just a basic compact issue, not a replication issue. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/

Re: General questions beginnergirl 30.08.2006 15:03:02 Okay....here it goes.... RE: Design Master I'm not really sure how I have occassionally lost my DM. The only time I have clicked on the button is when I have to make a new Design Master. But the reason that I have been sync'ing with it often is because we are on a lengthy project and each time we visit one of our stations, there has been a need for changes/corrections/updates so that in the end the data will be easily extractable. We are only on our 2nd station visit and have about 5 more to go through January. RE: File sizes I do the compact/repair prior to making the new replicas for the users but their replica files sizes seem to be different (not by much). I just have the users asking me why and it makes them worry that data is being lost although I have carefully researched this and there is no loss of data. "David W. Fenton" wrote: [Quoted Text] > beginnergirl <beginnergirl[ at ]discussions.microsoft.com> wrote in > news:9742539D-9A45-485F-9655-6A5A3864B34C[ at ]microsoft.com: > > > It's probably already out there but I can't see where anyone asks: > > > > 1. Does the synchronization process matter in what order you do > > it? Seems like depending upon the order, I've lost my Master > > Design. I've become quite the expert at recreating it but I'm > > tired of doing so. > > Why would you *ever* lose your DM? Makes no sense to me at all. > You'd only lose it if you check the box to make the target replica > the DM, but why would you do that if you hadn't lost the original > DM. > > Last of all, you shouldn't be synching often with the DM, or using > it for production editing. The DM should be kept aside and used for > one purpose: making design changes to the data table schema. You > need to synch with it every month or so to make sure that it doesn't > expire, but you shouldn't have frequent synchs with a DM unless > you're in the early development stages where your data schema is > still in flux. > > > 2. Why, once I have synchronized replicas with the Master design > > and made new replicas for the users, are their files sizes > > different? There doesn't appear to be missing data but I'm being > > asked and I just don't know why. > > If you compact them after the synch (twice if there was a design > change during the synch) they should all be the same size. This just > a basic compact issue, not a replication issue. > > -- > David W. Fenton http://www.dfenton.com/ > usenet at dfenton dot com http://www.dfenton.com/DFA/ >

Re: General questions "David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> 30.08.2006 21:26:24 beginnergirl <beginnergirl[ at ]discussions.microsoft.com> wrote in news:3F192BE3-7E72-4A68-ADE2-33792EF932D9[ at ]microsoft.com: [Quoted Text] > Okay....here it goes.... > > RE: Design Master > I'm not really sure how I have occassionally lost my DM. The only > time I have clicked on the button is when I have to make a new > Design Master. But the reason that I have been sync'ing with it > often is because we are on a lengthy project and each time we > visit one of our stations, there has been a need for > changes/corrections/updates so that in the end the data will be > easily extractable. We are only on our 2nd station visit and have > about 5 more to go through January. Are you carrying the DM with you? If that's the case, then that explains why you're losing your DM. You simply cannot synch with any replication except in its original permanent location. Putting a DM in a different location makes it a replica, in all circumstances. > RE: File sizes > > I do the compact/repair prior to making the new replicas for the > users but their replica files sizes seem to be different (not by > much). I just have the users asking me why and it makes them > worry that data is being lost although I have carefully researched > this and there is no loss of data. Read the Access help file on compacting. What you've written above leads me to believe that you might be confused about the role compacting plays in an MDB -- the size a replica starts out is simply irrelevant. It will grow as data is edited and changed, though much of that growth will be in temporary data pages that are marked unused and will be removed when the MDB is compacted. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/

Re: General questions beginnergirl 31.08.2006 01:59:02 Thanks so much for your help. I actually had read that the compacting is what removes all of the unnecessary stuff that takes up space so that part I do understand but will certainly take your advice and do more reading. "David W. Fenton" wrote: [Quoted Text] > beginnergirl <beginnergirl[ at ]discussions.microsoft.com> wrote in > news:3F192BE3-7E72-4A68-ADE2-33792EF932D9[ at ]microsoft.com: > > > Okay....here it goes.... > > > > RE: Design Master > > I'm not really sure how I have occassionally lost my DM. The only > > time I have clicked on the button is when I have to make a new > > Design Master. But the reason that I have been sync'ing with it > > often is because we are on a lengthy project and each time we > > visit one of our stations, there has been a need for > > changes/corrections/updates so that in the end the data will be > > easily extractable. We are only on our 2nd station visit and have > > about 5 more to go through January. > > Are you carrying the DM with you? If that's the case, then that > explains why you're losing your DM. You simply cannot synch with any > replication except in its original permanent location. Putting a DM > in a different location makes it a replica, in all circumstances. > > > RE: File sizes > > > > I do the compact/repair prior to making the new replicas for the > > users but their replica files sizes seem to be different (not by > > much). I just have the users asking me why and it makes them > > worry that data is being lost although I have carefully researched > > this and there is no loss of data. > > Read the Access help file on compacting. What you've written above > leads me to believe that you might be confused about the role > compacting plays in an MDB -- the size a replica starts out is > simply irrelevant. It will grow as data is edited and changed, > though much of that growth will be in temporary data pages that are > marked unused and will be removed when the MDB is compacted. > > -- > David W. Fenton http://www.dfenton.com/ > usenet at dfenton dot com http://www.dfenton.com/DFA/ >