Adding a new BI/Data Warehouse 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.

Using the Most Current Versions of the BI/Data Warehouse 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. 

Stopping a BI/Data Warehouse Query

If you are using MS Access, press the CTRL and BREAK (PAUSE) keys. You might have to do this three or four times to stop the query. If that does not stop the query, then press the CTRL, ALT and DELETE keys to abort your session.

Unable to Find a BI/Data Warehouse Table Using MS Access

If you get an error message when trying to access a table that you have used before, it could be caused by the following: 

  • The table name might have been changed,
  • You might have deleted it from your view,
  • It might be a new table that has been added to the BI/Data Warehouse, or
  • The table structure might have been changed since you used it last.

To resolve the problem, try re-linking the table. 

Updated 06/04/2019

Was this helpful?

Yes    No