I have a little bit of code which ran perfectly in Access 2000 but when it's run in 2002/3 it throws up a prompt for every append the query makes to the table
mySQL = "DELETE * FROM table_name"
DoCmd.OpenQuery "query_name", acNormal, acEdit
Am I missing something, it blocks all the other warnings, just not the append. Alternatively, is there any way of turning the Access program Action queries option on and off programatically?