Security Warning Messages Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I developed a database that has internal macros to assist in query
executions. This database was then compiled using the Microsoft Access 2003
Professional Tools into an *.mde module. The *.mde module was then
distributed to a few people at work along with the Microsoft Access 2003
Professional Runtime modules so that they could open the *.mde and use the
database. The problem is this. When they open the *.mde member from a
shortcut on their desktop, it opens a couple of boxes with warning messages.
The first warning box is this:

---------------------------------------------------
SECURITY WARNING

Opening "w:\DL\DR\^Shared\DICourses\DI-Courses-03.mde.

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?

Cancel button or Open Button or More Info Button

----------------------------------------

Is there a way to resolve this error "Security Warning Message" when the
database is first opened. It appears to be annoying to the end-user.

Thanks,

Robert Nusz
 
Robert:

This has to do with the macro security level set for Access. You can set a
registry key to set it to its lowest position, which would cause the prompts
not to run. However, since you are using the run time, the first time its
launched, they'll get the prompts and then you can have your auto exec run
code to modify the registry to lower the security warnings, which would
cause this not to occur again.

The reg key is:

HKEY_Current_User\Software\Microsoft\Office\11.0\Access\Security\

The Level Key sets the warnings, you may want to set this to 1; secondly
there may be issues with Jet's security settings as well which are under:

HKEY_Local_Machine\Software\Microsoft\Jet\4.0\Engines\

With the Sandbox mode. Search the KB for the values you may want to use
there.

Regards
 
Thanks for the quick response and update of information. This site has been
a real life saver for me and I've learned a lot by using it and its responses
to my queries. Hopefully the responses I've gotten have made it easier for
others as well.

Thanks Again.

Robert
 
Could you please provide a little more background into your explaination? I
have created a database in 2003 which is distributed over a remote server to
a small group. The server is running 2003 as well. I am not the IT
administrator so do not know about security levels. How can I too "override"
this message that appears each time the database is opened on the server?

Thank you!
 
Back
Top