Macro security in runtime version

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm developing an ADP in 2003. I'm deploying this using the package and
deployment wizard from the developer extensions. I'd like to set the macro
security level to Low to prevent those pesky startup meesages. However, the
client PC's don't have full Access 2003 installed (or any Office 2003 apps).
Short of getting an Authenticode certificate, is there any way to set the
macro security level manually or any other way to prevent the messages?

Thanks,
Barry
 
Hi, Barry.
Short of getting an Authenticode certificate, is there any way to set the
macro security level manually or any other way to prevent the messages?
Click to expand...

One may either use VBA code or change the Windows Registry keys. For more
information, please see end of the Security section on the following Web page
for a link to the tip, "How to set the macro security level in Access 2003
runtime":

http://www.access.qbuilt.com/html/how-to_tips.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
 
Thanks for your reply. The link you gave me didn't work, but it did point me
to a registry setting to eliminate the "unsafe expressions" messages.

Unfortunately, it still prompts for the digital signature warning. Any
thoughts?

Barry
 
Hi, Barry.
The link you gave me didn't work
Click to expand...

Sorry. The link is at the end of the VBA section, not the Security section
on that Web page. Did you find this tip (and please don't bookmark it
because it's the last item in that section, meaning it's on the last page,
and as we add more tips it's moved from page 1 to the sixth page, and will
undoubtedly keep gaining as time goes on):

http://www.Access.QBuilt.com/html/vba5.html#SetMacroSecLvl
Unfortunately, it still prompts for the digital signature warning. Any
thoughts?
Click to expand...

Sometimes Windows Registry settings don't work until you reboot. Try the
code in the click event of a command button on a form, instead. No reboot
required.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
 
Thank you. That was just what I needed.

Barry

'69 Camaro said:
Hi, Barry.


Sorry. The link is at the end of the VBA section, not the Security section
on that Web page. Did you find this tip (and please don't bookmark it
because it's the last item in that section, meaning it's on the last page,
and as we add more tips it's moved from page 1 to the sixth page, and will
undoubtedly keep gaining as time goes on):

http://www.Access.QBuilt.com/html/vba5.html#SetMacroSecLvl


Sometimes Windows Registry settings don't work until you reboot. Try the
code in the click event of a command button on a form, instead. No reboot
required.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
Click to expand...
 
Back
Top