Changes to multi-user app after splitting? CW 24.09.2006 19:38:01 I have built a database that is going to be used by 6 persons, running the back end on a SBS 2000 server. I have read a fair amount about splitting, which everybody seems to say is A GOOD THING to do. Question: once I have done the installations and the splitting, and everything is installed and running, if (no, when) I make changes to anything (for example the layout of a form, or if I add another field to a table) do I just do the update once and it will be seen by everyone? What are the types of change that DO have to be done individually, locally at each PC? Many thanks CW

Re: Changes to multi-user app after splitting? "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 24.09.2006 20:15:12 Nothing should have to be done locally at each PC. All you do is replace the current front-end MDB file with the new one. To automate the process somewhat, take a look at the free AutoFE Update Tony Toews has at http://www.granite.ab.ca/access/autofe.htm -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "CW" <CW[ at ]discussions.microsoft.com> wrote in message news:297B2A0E-29CC-4148-B135-B713BAF08EF9[ at ]microsoft.com... [Quoted Text] >I have built a database that is going to be used by 6 persons, running the > back end on a SBS 2000 server. > I have read a fair amount about splitting, which everybody seems to say is > A > GOOD THING to do. > Question: once I have done the installations and the splitting, and > everything is installed and running, if (no, when) I make changes to > anything > (for example the layout of a form, or if I add another field to a table) > do > I just do the update once and it will be seen by everyone? > What are the types of change that DO have to be done individually, locally > at each PC? > Many thanks > CW >

Re: Changes to multi-user app after splitting? CW 25.09.2006 22:37:01 That's good news! Many thanks, Doug. CW "Douglas J. Steele" wrote: [Quoted Text] > Nothing should have to be done locally at each PC. All you do is replace the > current front-end MDB file with the new one. > > To automate the process somewhat, take a look at the free AutoFE Update Tony > Toews has at http://www.granite.ab.ca/access/autofe.htm > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "CW" <CW[ at ]discussions.microsoft.com> wrote in message > news:297B2A0E-29CC-4148-B135-B713BAF08EF9[ at ]microsoft.com... > >I have built a database that is going to be used by 6 persons, running the > > back end on a SBS 2000 server. > > I have read a fair amount about splitting, which everybody seems to say is > > A > > GOOD THING to do. > > Question: once I have done the installations and the splitting, and > > everything is installed and running, if (no, when) I make changes to > > anything > > (for example the layout of a form, or if I add another field to a table) > > do > > I just do the update once and it will be seen by everyone? > > What are the types of change that DO have to be done individually, locally > > at each PC? > > Many thanks > > CW > > > > >

RE: Changes to multi-user app after splitting? Tom Wickerath 29.09.2006 03:51:02 Hi CW, [Quoted Text] > ...or if I add another field to a table... To add just a bit to Doug's answer, if you make any design changes to the BE database (add or remove fields, indexes, etc.), I recommend that you delete the table link in the FE database, compact the DB, and then re-create the link from scratch using File > Get External Data > Linked Tables. Tom Wickerath Microsoft Access MVP http://www.access.qbuilt.com/html/expert_contributors.html http://www.access.qbuilt.com/html/search.html __________________________________________ "CW" wrote: > I have built a database that is going to be used by 6 persons, running the > back end on a SBS 2000 server. > I have read a fair amount about splitting, which everybody seems to say is A > GOOD THING to do. > Question: once I have done the installations and the splitting, and > everything is installed and running, if (no, when) I make changes to anything > (for example the layout of a form, or if I add another field to a table) do > I just do the update once and it will be seen by everyone? > What are the types of change that DO have to be done individually, locally > at each PC? > Many thanks > CW