I have an automated process which splits one large database into 32 smaller databases based on the value of a field. The database was originally created in Access 97. My company is moving to Access 2003, and I am working on the conversion of the database.
I am receiving a Security Warning that is stopping my automated process. Company standards have set the default security level to Medium, so my app won't open without intervention.
It seems that the AutomationSecurity property should resolve this issue, but I am have difficulty getting the coding right.
Anyone have some sample code to temporarily change the security level of an Access app on startup, and then change it back one the app is open?
I am receiving a Security Warning that is stopping my automated process. Company standards have set the default security level to Medium, so my app won't open without intervention.
It seems that the AutomationSecurity property should resolve this issue, but I am have difficulty getting the coding right.
Anyone have some sample code to temporarily change the security level of an Access app on startup, and then change it back one the app is open?