Access 2003 runtime mode-can't turn off warning messages for macro

MS Office Access


  • 1. Access 2000 Database won't open
    I am working with several Access 2000 databases. I worked in one of them this morning and after exiting and re-opening the database it only displays a blank page. It doesn't appear to even open at all. The other databases work fine. The file size of the database is still the same, so the data appears to still be there. Any advice?
  • 2. Passwords and Oracle
    Is there a way to put my password in the driver so I don't have to enter it in every time I need to relink to a table in Oracle?
  • 3. Populating certain fields in form2 with the same data that form1 h
    Hello, I am making a warranty claims form. And I want to be able to populate certain customer info after I select his serial number from a combo box. The serial numbers and customer info are located in the warranty registration form that were entered in earlier. How do I accomplish this? Thanks Dustin

Access 2003 runtime mode-can't turn off warning messages for macro

Postby Qml0c3k » Mon, 07 Feb 2005 02:53:05 GMT

In Access 2003 I turn off all the warning messages in the Edit/Find tab under 
Tools + Options for my data base.  I then package it with the Access 2003 
Developer Extensions Tools Wizard into a  .dme runtime package.  When I run 
it on another computer other than mine, a computer with Access on it or one 
without Access on it, I get all the warning messages for macros and queries, 
as if I never turned off the Warning messages in the Edit/Find tab.  Any 

Re: Access 2003 runtime mode-can't turn off warning messages for macro

Postby Rick Brandt » Mon, 07 Feb 2005 03:06:17 GMT

Yeah, those options are for "your installation of Access" Only a few of the 
options in Tools - Options are "for this particular file" and they are labeled 
as such.

If you're far enough along in Access development to be packaging solutions with 
the Developer's Extensions you should not be using macros (especially in the 
Runtime). Action queries can avoid the prompts by using either...

DoCmd.SetWarnings False
DoCmd.OpenQuery    (or DoCmd.RunSQL)
DoCmd.SetWarnings True

or (even better)

CurrentDB.Execute "QueryName", dbFailOnError

The latter does not produce the prompts in the first place.

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com 

Re: Access 2003 runtime mode-can't turn off warning messages for macro

Postby Albert D. Kallal » Mon, 07 Feb 2005 05:08:52 GMT

Simply add the following keys to your runtime packing (the package wizard 
does have provision for adding regs keys).

ROOT:Local Machine
Key: SOFTWARE\Microsoft\Jet\4.0\Engines

ROOT:Local Machine
Key: Software\Microsoft\Office\11.0\Access\Security

If you add both tof the above, then you get no security prompts at 
all...even if the later jet sp8 is NOT installed. It is clean...and no 

Albert D. Kallal   (Access MVP)
Edmonton, Alberta Canada

Similar Threads:

1.Turning off warning messages in Access Runtime

Insert into your macro as the first step:
    Action: SetWarnings
        Expression:  No

Then insert after the queries are run:
        Action: SetWarnings
        Expression:  Yes

       Ken Snell

"Doug Hart" < XXXX@XXXXX.COM > wrote in message
news:02bb01c34578$e6cafa80$ XXXX@XXXXX.COM ...
> I have an application that uses Access Runtime.  How do I
> turn off the warning messages when queries are executed?
> The screen comes up and offers a "Help" button, but then
> displays nothing when I click on it.  I cannot find any
> settings file that is packaged with the application to
> make the change.  The macro needs to run without any user
> interaction as part of an unattended overnight process.
> Any help would be greatly appreciated!

2.Turn off warnings in Access 2003 runtime

    The MSDN people have refused to send me the Windows Component Update for
Office XP Developer, or let me download it. So I've moved onto Office 2003
and left the database in Access 2000 format. However, I get the warning
everytime "file may not be safe", then the user must click Open or Cancel.
If they had the full version of Access, I could select Tools/Macro/Security
and set it to low. How can I get around this on machines with only the
runtime version?
    Also, some PCs get the warning about unsafe expresssions, even after
I've installed Jet 8. Any ideas on this?

3.Access 2003, turn off macro warnings - help please

4.Office 2003 - Turn off macro disabled message

I know there is an option in Office 2007, however is there an Option
in Office 2003 not to show the message that macros have been
disabled?  I have thousands of documents I'm trying to print to PDF
and as part of it the documents are launched to print.  I do not want
it to use macros when printing (even though there are some in the
documents), and do not want it asking me.  I set it to high and very
high security and both of those physically tell me the macros have
been disabled and want me to hit OK.  Office 2007 has a disable and
don't inform me option, but do not see this option in 2003.  Any
assistance?  Would hate to have to sit there and click OK several
ten's of thousands of time.



5.warning message Access 2000 cant turn off

I am running a docmd "openhyperlink" and when the 
hyperlink is about to be loaded a message appears 

"Some files can contain viruses or otherwise harmful to 
your computer, it is important to be certain that the file 
is from a trustworthy source" Would you like to open the 

I have spent hours trying to turn this message off, does 
anyone know how to disable this message. I have 
tried "Setwarnings" with no luck.

6. Turn off data access web component warning messages

7. How do I turn off prompts for security warnings in Access 2003

8. How turn off security warning in Access 2003

Return to MS Office Access


Who is online

Users browsing this forum: No registered users and 13 guest