Modify backend table with new field
Posted on 2016-07-26
Environment Desktop Access 2013 database with front end and backend (standard).
When starting, a bat file copies a master FE to a temp area and then executes the FE from the temp area.
I have a number of different sites, each with their own separate network, the same copy of the FE and their own BE.
The BEs are structurally the same.
Problem: I need to add a field to the standard BE.
Normally, I put a new version of the FE to the various sites, the FE software checks the version of the BE and if neccessary manipulates it so the BE is compatible with the new FE version. For example, I can add a new table to the BE from a deployed FE.
The question is - how do I code it so that it adds a field to a backend table. I know how to do that for adding a field to a database but not when the table is linked. Any ideas.