How to set the Access 2003 Security Level to Low for all user profiles


By default the Security Level in Access 2003 is set to Medium (Tools > Macro > Security). If a database has macros built in then you will be prompted with a couple of messages regarding ‘blocking unsafe exceptions’ and ‘do you want to continue to open.’

My particular issue was with an Access 2003 database that was to be accessed by a large number of users via a Terminal Server.

To suppress these messages you need to set the security level to ‘low’. Although you can do this in Access itself, this only applies to that user profile.

To set across all user profiles you need to add the following registry key (obviously take a backup of the registry before making any changes)

I had to create the Security key as it didn’t already exist.

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice11.0AccessSecurity]
"Level"=dword:00000001

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s