Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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.

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

Comments

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

Loading comments...