on that, the first task is to demonstrate access VBA code can pass a parameter to SQL query using ADODB connection string. FYI : SSMA Wont work with SQL 2009 R2 as its EOF so have to live with ...