Data Warehouse MS Access How Tos

Having issues? See our BI/Data Warehouse troubleshooting tips

IT Services recommends using MS Access or SAS EG for accessing BI/Data Warehouse. An ODBC driver is required, which is usually installed by the BI/Data Warehouse team. 

Microsoft Access is the most common product used to access the BI/Data Warehouse. 

Add a New Table Using MS Access

  1. Go to File.
  2. Select "Get External Data."
  3. Select Link Tables.
  4. On the Link Screen, go to "Files of Type." Select from the list ODBC Database.
  5. On the Select Data Source screen, select "Machine Data Source," then double-click on DWH32.
  6. Enter your password (if requested) and highlight the table(s) you want to add. Click OK.
  7. On the Select Unique Identifier screen, click OK.

Use the Most Current Versions of Tables in MS Access

To avoid using outdated tables, make sure you have the most current version of BI/Data Warehouse tables in MS Access every month: 

  1. Click on your BI/Data Warehouse icon.
  2. From your menu bar, select EXTERNAL DATA and then select "LINKED TABLE MANAGER."
  3. When the tables are displayed, select the tables you want or select "ALL." Click OK. If a table no longer exists at that location, you will be prompted for a new location.