Blog Post

Trust in Access

,

One of the minor features/quirks/annoyances of MS Access is that if you create a single macro or code module you get a prompt to ‘Enable Content’, designed to prevent malicious code from running without you knowing it. I tend to just leave it open for long periods and so it doesn’t bother me much, but this week I was packaging up something for someone else to run and wanted to remove this if I could.

image

It turned out to be easier to do than I expected. If you open up the Trust Center there are a bunch of options. Rather than deal with signing, I went with the second option on the menu, trusted locations. Since it was going to be in a standard location I just set that folder to be trusted (C:andy in the gray line below). Worked the first time! Not the right solution if you need real security, but this is a one-off with no sensitive data and the user will appreciate it – now I can set an autoexec macro that will do 90% of what they need without them thinking about it.

image

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating