If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table construction
Hi. I have done the frontend - backend bit and now everyone has their own
frontend on their desktops. (Yippee it worked) How do now do standard improvements to forms etc, and also keep track of the individual customised desktop changes ?? And what happens when I add tables? Do I then have to link them individually to each front end? And that's just the start I suppose :=) |
#2
|
|||
|
|||
Table construction
Have a look at Tony Toews Auto FE Upater a this link;
http://www.granite.ab.ca/access/autofe.htm -- _________ Sean Bailey "Marie" wrote: Hi. I have done the frontend - backend bit and now everyone has their own frontend on their desktops. (Yippee it worked) How do now do standard improvements to forms etc, and also keep track of the individual customised desktop changes ?? And what happens when I add tables? Do I then have to link them individually to each front end? And that's just the start I suppose :=) |
#3
|
|||
|
|||
Table construction
As Sean suggested, you can distribute your improved front end using Tony's
Auto FE Updater. Are you saying, though, that your users are going to be making changes to their copy of the front-end, and you want to preserve those changes? There's no way to automate that. A more common approach is to lock down their front-end, and allow them to create their own reports (and forms, if it comes to that) in another database that you won't overwrite when you redistribute the "official" front-end. Since your front-end will have links to the new tables, distributing the front-end to others will include those new tables. When you can run into issues, though, is if you've used mapped drives to link to the back-end and the other users don't have their drives mapped the same way. One way around that is to use UNCs (\\server\share) when linking. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Marie" wrote in message ... Hi. I have done the frontend - backend bit and now everyone has their own frontend on their desktops. (Yippee it worked) How do now do standard improvements to forms etc, and also keep track of the individual customised desktop changes ?? And what happens when I add tables? Do I then have to link them individually to each front end? And that's just the start I suppose :=) |
Thread Tools | |
Display Modes | |
|
|