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?.
LVL 1
ReefITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.