Bypass macro security in Access 2003 1

[captphan]

Every time I give a project I ahve worked on to an end user they are attacked by warnings about how the databse may harm ther computer. I have created a signature but this doesn't seem to help. Does anyone know where they hid the setting so I can stop these warnings.

 

[pbaldy]

I don't have 2003 handy, but if memory serves look in Tools/Macro/Security.

Paul
MS Access MVP 2007/2008

 

[jrbarnett]

If you used selfcert to generate your code signing certificate this doesn't contain a path to a root certificate authority, hence won't be usable by your application.

Without buying a full code signing certificate suitable for VBA developers, the next best way is to set up trusted paths for the database location in the Office setup (can be delivered through a group policy to the machine or user on the network).

John

 

[captphan]

John,
This sounds perfect. Can you give me more detail on how to do this?

 

[jrbarnett]

General information on security principals for Office code and macro security:

http://office.microsoft.com/en-us/ork2003/CH011480831033.aspx

Trusted location defaults for Office 2003

http://office.microsoft.com/en-us/ork2003/HA011403181033.aspx?pid=CH011480851033

Macro security in Office 2003

http://office.microsoft.com/en-us/ork2003/HA011403071033.aspx?pid=CH011480831033

To set the paths as group policies (to force it on everybody), you will need your network administration staff to set this up. Long term it will be more manageable than individually setting the folders for each PC or user account.

John

 

[Remou]

It is also possible to self-certify VBA projects:

http://office.microsoft.com/en-us/access/HP010397921033.aspx