Access 2003 and Macro Security settings...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

plsntn_rules - 30 Sep 2004 17:52 GMT

We are using Access 2003 as a reporting tool for our CRM
implementation.

If the CRM report is run locally on the server on which
Access 2003 is installed we have no warning messages
showing up.

But the way we have end users accessing the CRM application
is thru a Citrix session and when they run the report they
get the following warning window:

"Security Warning

Opening Z:\xxxx.mdb
This file may not be safe if it contains code that was
intended to harm your computer.
Do you want to open this file or cancel the operation?

Yes or No"

If they chose Yes, the report opens up fine. If they chose
No it does not spawn the report.

So my question is how to we make it so that users do not
get this warning message?

Is there a command line switch that can be added tot he
code that calls the Access 2003 appliation that will turn
off this warning?

I have looked at the following articles:

http://support.microsoft.com/default.aspx?kbid=294698

and it works fine like I said locally on the server but has
no mention of how to disable this on a per user basis that
are accessing it thru a citrix or a WTS session.

Is there a policy setting, a command line setting anything?

thank u ver much for any help.

Reply to this Message

Paul Sanguinetti - 02 Oct 2004 17:47 GMT

I'm currently in the process of dealing with this same situation. The only
way I've been able to get it to work is to create a digital signature
certificate, and attach the certificate to the db. I'm still not sure if that
will eliminate the messages in all cases, but it seems to be working so far.
The only other thing I've found that may address the problem is to set the
security level in Access 2003 to LOW, which pretty much defeats the whole
purpose of security. I've yet to figure out how to turn off the noise for
db's older than 2003 that don't allow for attaching a certificate or
instructing Access that it's ok to run this mde via switches or an approved
ap table, etc.

> We are using Access 2003 as a reporting tool for our CRM
> implementation.
[quoted text clipped - 37 lines]
>
> thank u ver much for any help.

Reply to this Message