By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,678 Members | 2,155 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,678 IT Pros & Developers. It's quick & easy.

Method for updating production backends with new tables/fields

P: n/a
My application is beginning to interest prospective clients. This may be
wishful thinking, but if I have a lot of clients how will I update a
production backend when I need to add tables (for example, for new
functionality in the new release front end) or modify tables with fields.

The clients I talk to generally do not allow executables to be installed on
user PCs. So an executable to do this is out of the question. If by some
miracle I have 50 or more clients, how am I going to accomplish adding new
tables to the production backend or adding a field to an existing table. I
don't want to have to accept each backend one by one and do the changes.
Code is the answer, but how to best implement this.

Of course, before anything is done, backup, backup, backup.....

Advice, suggestions experience on how to best accomplish this is appreciated.

Thanks.

--
Message posted via http://www.accessmonster.com
Dec 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
One of these two should answer your question, or maybe the one you meant to
ask. If not, there are other portions of Tony Toews' site that should help
you out.

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

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

--
Darryl Kerkeslager
Dec 14 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.