MS Access:
SQLNativeSql
Using SQLBrowseConnect to connect to a data source through a number of iterative calls (SQL Server)