• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1157
  • Last Modified:

Access 2003 run-time. How to lower the macro security.

Hi all,

I have developed a small access 2003 application. The target PCs only have Office 2003 standard installed. (i.e no access)
I have used the 2003 developer extensions to create a custom install including the access runtime.
The application installs and runs properly.
The only problem is the "block un-safe expression" security warnings at application startup. This is causing confusion for the users who think the app is not running properly.

How can I set the macro security level for this app to get rid of these messages?.
0
ReefIT
Asked:
ReefIT
2 Solutions
 
dekkarCommented:
you dont mean Tools --> Macro --> security ---> Low


do you?
0
 
ReefITAuthor Commented:
no... don't think so.

The target PCs don't have access installed.

The app runs from the runtime version of access installed from the setup routine.
0
 
ldunscombeCommented:
You could use a digital certificate.

Refer the accepted solution in this ee post for more details.

http://www.experts-exchange.com/Networking/Protocols/Application_Protocols/SSL/Q_23095168.html

Leigh
0
 
ldunscombeCommented:
I'm not 100% sure but I think if you set the macro security to low in excel it will apply to Access as well.

Tools --> Macro --> security ---> Low

As I said can't be sure and I wouldn't think it would be your preferred option anyway.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
However, be very careful setting macro security to Low ... if you do this, make SURE your endusers (or their IT department) know what is going on. There has been a recent virus scare in regards to Access databases: http://vil.nai.com/vil/content/v_vul35540.htm

Much better, in my opinion, to do it the correct way and use a digital cert as leigh suggests earlier. That link, however, suggests the use of self-certs, which may be suitable for you use. If you are delivering to endusers outside of your network (i.e. clients) you'd be wise to invest in a commercial certificate for these purposes.

Here's the MS article about applying and using Digital certs with an Access application:

http://office.microsoft.com/en-us/access/HA011225981033.aspx?CTT=42 
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now