SetWarnings vs. "Confirm Action Queries" - what's the different

[smig]

DoCmd.SetWarnings False
Application.SetOption "Confirm Action Queries", False


what's the different between these two ?
which one should I use in code ?

 

[ajetrumpet]

DoCmd.SetWarnings False
Application.SetOption "Confirm Action Queries", False


what's the different between these two ?
which one should I use in code ?

confirm action queries is an option to set permanently. setwarnings is temporary until you turn it back on or restart the application

 

[boblarson]

confirm action queries is an option to set permanently. setwarnings is temporary until you turn it back on or restart the application

DoCmd.SetWarnings if used will also affect all other Access databases until it is reset.

The confirm Action Queries is a PER USER setting and not a per database setting.

 

[smig]

thanks
so I guesss it's better to use the "Confirm Action Queries" one, though I found it might not supress all messages (like deleting a record with childs)

 

[boblarson]

thanks
so I guesss it's better to use the "Confirm Action Queries" one, though I found it might not supress all messages (like deleting a record with childs)

The problem with unchecking the Confirm Action Queries checkbox is, as I believe, it is only good on your machine. I believe it is a PER USER setting and not a PER DATABASE setting. So if you uncheck it on your machine, you would have to go uncheck it on every other machine that is using your database. I could be wrong but I seem to remember that it was that way.

 

[boblarson]

I just verified that it IS a PER USER setting. So, if you want to set it for each user you have to use the application properties.

http://support.microsoft.com/kb/205425

 

[smig]

I Uncheck nothing
I do it all by code, and I put it back after I run the query

 

[gemma-the-husky]

so maybe theres no difference - is it an A2007 way of doing the same thing

 

[smig]

I'm using Access 2003