Enable Content / Macros in 2007
Whenever I would do this, I'd simply enable the content once and set my trust center macro settings to 'always trust macros'. That would surpress the message on a permanent basis after that.
But I'm dealing with someone right now that is claiming that process doesn't work, and the message still appears on subsequent opens of the db file.
I'm going to google this of course, so I'm simply checking to see if there is anything under the surface that you guys know about that I might not
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I know that I can manually enable macros through the trust center and I could also add a trusted location (could prob. also automate a registry update to do same). My preference though isto enable macros using a script as over 600 users will, on occasion, use these databases and I don't want to spend my days telling people how to enable macros.
I read that the macro must have a digital signature, and followed the path to select one, but there were no certificates to select. I'm sure I probably wouldn't want to enable all macros, but none of the other paths lead me to anything useful.
How can I get by this, and will I need to do it for every db I create or convert from here on out
The error on the macros says that steps won't work if the database is not trusted.
I know this opens the application to macro viruses, but again if you have to enable it anyway, I am not sure I see the point.
Can someone please let me know if they there would be a reason for not just permanently enabling them.
In this article:
* What is a macro and what is the security risk?
* Enable or disable macros with the Trust Center
* How can the Trust Center help protect me from unsafe macros?
* A security warning asks if I want to enable or disable a macro. What should I do?
The only way I can click the enable button is to right click and select Design view. I haven't notice this behaviour before when developing in Access 2007 (I am using Access 2010 now).
This would of course cause a problem when I distribute it later as ACCDE to end users. Any idea why I need to go into design view to click the Enable content button?
I want the code to enable macros just for what that database and not the whole Access application
In this article: What is a macro? Understand macros; New macro features in Office Access 2007; Create a macro; Run a macro.
In this article you'll learn: What is a macro? Understand macros, New macro features in Office Access 2007, Create a macro, Run a macro.