Set Warnings not trusted in Access 2007

  • Thread starter Thread starter John M
  • Start date Start date
J

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.
 
I have also added the database folder on C:\ to the trusted locations list
but still have the problem.
 
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.
 
What's the answer to this question? I am experiencing the same problem.
"
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."
 
Back
Top