Linking MS Access with an ODBC Connection to the Data Warehouse
1. Click on the External Data tab and then select ODBC Database.
NOTE: PLEASE make sure to select the Link to the data source… option.