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


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.


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.



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

Loading comments...