The video below shows you how to call ANY native server side SQL statement from MS  Access.  This includes functions, stored procedures, DDL, DML, etc.  Not  only that, but performance is significantly faster compared to using  ODBC Linked Tables through