Macro security in runtime version

[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

 

[Guest]

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?

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.

 

[Guest]

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

 

[Guest]

Hi, Barry.

The link you gave me didn't work

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?

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.

 

[Guest]

Thank you. That was just what I needed.

Barry

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.