Couple of questions to make sure I understand how you are set up.
By "forms", are you essentially referring to a customized UI used to access a cetralized DB?
If the answer is yes - possibility 1:
It's been a long time since I've done and VBA coding or Access design, so I'll have to talk conceptually here.
It should be possible to place a single locked (and maybe hidden) table in the forms. This table would consist of a single field called "Last update" with the field populated with info pertaining to the creation date of the currently installed form. Create a similar table in your centralized DB that is populated with info pertaining to the most updated form.
Then create an embedded (and maybe hidden) macro in the form that runs automatically as soon as the DB is opened. The he macro would essentially do the following:
Compare FormTbl/LastUpdate with DbTbl/LastUpdate
If fields are not equal
Send user notice to install updated table
Exit database Else
Continue
End
How are you currently distributing updated forms?
Another possibility might be to not distribute the forms but also place them centrally. Place only shortcuts to the forms on the users' computers. Then you will ensure that users are using only the latest versions.
If I've misread how your database is structured and being used, disregard all of the above.
Hope this helps.
