>When I try to run an INSERT command, I get prompted with the message "You are about to append 1 row(s).....", and when I try to run a DELETE command I get "You are about to delete 1 row(s) from the specified table.....".
>
>If I click No on either 1 of these, I get a 'Runtime Error. The RunSql action was cancelled".
>
>Is it possible to turn off these warnings?

See

http://www.databasedev.co.uk/suppress_warnings.html