I would like to update programmatically the macros security level setting in MS Access 2007. That is I don't want to go through Access menu toolbar.
Also I would like to run it from a vbscript that will open the Access application and change its macro setting.
Finally I would like to change the settings back or reset them to default when the application closes.
I would greatly appreciate any assistance.