vba - Nothing I Do Will Disable Access Warnings -

i've tried of suggestions....

• access options, confirm settings action queries
• vba setwarnings off , on
• the db in trusted folder location

no matter still warnings / confirmation popups in access when running forms , macros. else overriding settings?

is possible group policies override settings? how find policy settings?

we have process run in access 2x monthly, , takes long because users have click yes on popups. i've tried obvious tricks, nothing prevents these confirmation popups.

if using vba execute sql, try use:

currentdb.execute strsql 

instead of

docmd.runsql strsql 

where strsql represents sql statement trying execute.

this automatically suppresses normal warnings running query, still give other errors, such when sql invalid. can use items query, such amount of records affected query, otherwise cannot docmd statement.