I have access as my interface to a mysql database. I use the mysql odbc
driver to connect and everything works fine; however, whenever I make an
insert or update to the database I get message boxes telling what is going
to happen and if it is okay. I have some sections of code that might update
the database 3 or 4 times and it is getting annoying to continually have to
accept the message boxes. Is there a way to turn those off?

Try:
SetWarnings
Don't forget to turn it back on again.

Alternatively, use the Execute method of CurrentDb() instead of RunSQL.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"itHeiner" <(E-Mail Removed)> wrote in message
news:17EC9FE2-70CB-421B-965E-(E-Mail Removed)...
>I have access as my interface to a mysql database. I use the mysql odbc
> driver to connect and everything works fine; however, whenever I make an
> insert or update to the database I get message boxes telling what is
> going
> to happen and if it is okay. I have some sections of code that might
> update
> the database 3 or 4 times and it is getting annoying to continually have
> to
> accept the message boxes. Is there a way to turn those off?

Thanks, that did it.

"Allen Browne" wrote:

> Try:
> SetWarnings
> Don't forget to turn it back on again.
>
> Alternatively, use the Execute method of CurrentDb() instead of RunSQL.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "itHeiner" <(E-Mail Removed)> wrote in message
> news:17EC9FE2-70CB-421B-965E-(E-Mail Removed)...
> >I have access as my interface to a mysql database. I use the mysql odbc
> > driver to connect and everything works fine; however, whenever I make an
> > insert or update to the database I get message boxes telling what is
> > going
> > to happen and if it is okay. I have some sections of code that might
> > update
> > the database 3 or 4 times and it is getting annoying to continually have
> > to
> > accept the message boxes. Is there a way to turn those off?
>
>
>