SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

SQLAndy

I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

Comments

Leave a comment on the original post [www.sqlandy.com, opens in a new window]

Loading comments...