I use a seperate access program to update the front ends.
The prog has one form with one button on it called “Install Upgrade”. This button then runs VBA code or Queries to update either the FE or BE tables etc. Below is an example of the VBA to add a new field.
Dim db As Database, tdf As DAO.TableDef, fld As DAO.Field
Dim prp As DAO.Property
On Error Resume Next
Set db = OpenDatabase(“M:SMDatasmdata.mdb”)
Set tdf = db.TableDefs!Units
db.Execute “ALTER TABLE Units ADD COLUMN InstallFee CURRENCY;”
db.Execute “UPDATE Units SET InstallFee = 0 ;”
‘Set fld = tdf.Fields!InstallFee
‘Set prp = fld.CreateProperty(“Format”, , “Currency”)
‘Set prp = fld.CreateProperty(“DisplayControl”, dbInteger, acCheckBox)
Set db = Nothing
I have functions for adding different types of fields in a module and then just select (and modify) the function to suit. I even use this type of thing to populate any new fields afterwards.
It’s only limited by your imagination.