Table construction

[Marie]

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 :=)

 

[Beetle]

Have a look at Tony Toews Auto FE Upater a this link;

http://www.granite.ab.ca/access/autofe.htm

 

[Douglas J. Steele]

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.