Set Warnings not trusted in Access 2007

[John M]

I have an Access 2000 db with the following macro that will not run using
Access 2007:

Set Warnings No
Run Query 1
Run Query 2
etc
Quit

Access 2007 is putting a yellow triangle next to Set Warnings and Quit in
the macro design view. The Help for Set Warnings indicates the database must
be "trusted" for this command to work so I have followed the Help
instructions to trust the database to myself. However the macro still will
not run. The database has to stay Access 2000 or 2003 because of other
software it interfaces to. Thanks for your help.

 

[Clifford Bass via AccessMonster.com]

Hi John,

How did you specify that it is trusted? Did you make sure your Macro
Settings in the Trust Center allow macros?

Clifford Bass

 

[John M]

I have also added the database folder on C:\ to the trusted locations list
but still have the problem.

 

[Clifford Bass via AccessMonster.com]

Hi John,

The warning icon shows regardless of whether or not it will run and
whether or not the database is trusted. Double checking: Does it actually
refuse to run? What message, if any, do you get? If none, how do you know
it did not run?

Clifford Bass

 

[John M]

Thanks for the reply. Upon further review it wasnt failing on the Set
Warnings command after all. The Quit command at the end was closing Access
before I could see the error message. It has a RunCommand--View Tables that
is supposed to open the database window showing all the tables (as in Access
2000-2003). The error message says View Tables is not available now.
Apparently this is not supported in Access 2007. I can live without it, it
was just cosmetic. Thanks again.

 

[Clifford Bass via AccessMonster.com]

Hi John,

The ViewTables command will give you that error if you are in macro
design view. If you close the macro (all macros) out of design view and just
run it, it will work.

Clifford Bass