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.