Upgradable Application

[Cosmic]

How do you create an Access Database program that can be upgraded with future
upgrades, bug fixes, and enhancements? I would like to send upgrades to
users without disrupting the underlying data.
I have read that separating the tables in one database and all other objects
in another database allows you to upgrade the objects without affecting data.
However, the book said that it would not help if you have to upgrade the
table (for example adding another field).
Is their a better way to build applications that are upgradable?

 

[Allen Browne]

Splitting lets you release updates to the front end easily.

If you need to change the data structure, you will need to add the fields,
tables, indexes, relations, and their properties to the client's existing
back end programmatically. See the CreateField method (DAO library) for
details and an example.

There are some commerical utilities available, e.g. DataPro under the
Products at http://www.ssw.com.au/