Access: Confirm Record Changes and Action queries keeps resetting

[Pawaso]

For some reason the "Confirm" for "Record changes" and "Action queries"
options keep resetting. I indeed want the confirmation, yet intermittently I
go into "tools> options> Edit/Find> Confirm" and the boxes are "unchecked"
again. Anybody know why this keeps happening, or do you know how to prevent
it from resetting?

 

[Alessandro Baraldi]

Pawaso ha scritto:

For some reason the "Confirm" for "Record changes" and "Action queries"
options keep resetting. I indeed want the confirmation, yet intermittently I
go into "tools> options> Edit/Find> Confirm" and the boxes are "unchecked"
again. Anybody know why this keeps happening, or do you know how to prevent
it from resetting?

Are you using RunSQL method...?

Docmd.SetWarning False
Docmd.RunSQL "YOUR ACTION QUERIES..."
Docmd.SetWarning True

If you use the Execute Method member of Database Object you don't need
anything else:

CurrentDb.Execute "YOUR ACTION QUERIES..."

To uncheck definitivly the "Confirmation" box on Application Database
is not a good
idea..., much better disable only on request....

@Alex