Back End Update Utility by Peter Hibbs
http://www.rogersaccesslibrary.com/forum/back-end-update-utility_topic410&SID=3f46b4fz-b418-3e1584c6-az9e8cc2-128713d6.html
he purpose of the attached code is to allow Access developers to make changes
to their clients back end file automatically. The front end holds a table which
defines a list of changes required in the back end schema. When the client runs
the database, any changes required are first made automatically to the client's
back end file and then the program continues as normal. The attached Word
document gives full details on setting up the system.
This version has the following additions :
Added Hyperlink type fields.
Added Caption property.
Added Rich Text property for memo fields (Access 2007).
Added Smart Tags property (Access 2007).
Added Attachment type field (Access 2007).
Added facility to create reference table in BE automatically.
Added tutorial using Northwind database.