Executing SQL Statements in VBA Code. There are a number of ways to execute a SQL Data Manipulation Language (DML) statement from Microsoft Access, besides the obvious process of creating an Action Query and double-clicking its icon.
Understanding your options with respect to executing SQL will make your code cleaner, give you more flexibility and we'll even throw in a great debugging feature as an added bonus. The following article, while not exploring every facet and option, will demonstrate how to execute SQL using the following methods: Sql - What is the difference between Left, Right, Outer and Inner Joins. SQL Quick Reference. Using append quries to populate tables in Access 2010. Append Query Key Violation.