Connecting to Access

Contents[Hide]

1. Overview

This article describes options available when connecting to a Microsoft Access file data source.

Note
See the Dundas BI system requirements for your installed version of Dundas BI to confirm that it supports connecting to Microsoft Access.

Main article: Connect to data and view it on a dashboard

2. Drag and drop an Access file

The easiest way to work with an Access file is to drag it from Windows Explorer or Finder and drop it directly into Dundas BI, onto the Explore window or the canvas of the file you're working on.

Drag Access database file to Explore
Drag Access database file to Explore

This will automatically create a corresponding data connector in Dundas BI. Expand the data connector and drag a table to the canvas to see its data.

Access data connector is created automatically
Access data connector is created automatically

This is similar to dragging and dropping an Excel file.

3. Connect to Access file

You can also create a data connector, then either choose a file to upload or specify its location. See Connect to data and view it on a dashboard for a general walkthrough on creating and using a data connector.

After setting the Data Provider to Microsoft Access for a data connector, specify the Access file you want to connect to using one of these options:

  • Click Choose File and select an Access file to upload to Dundas BI. This version of the file will be used as the data source, and it will not be updated with any future changes unless replaced by editing the data connector and uploading a new file in its place.
  • Or, use the Data Source or UNC Path option to specify the full network path to the file. The data connector will access the file at this location, and changes to this file will be reflected in Dundas BI. Example: \\server1\shared\MarketData.mdb

Choose the Access file or specify its network path
Choose the Access file or specify its network path

If you specified the path to your file rather than uploading it, click the Authentication dropdown to choose an authentication method used for accessing the location you specified. For example, set it to Specified Windows credentials and enter the domain, username, and password for a Windows account that has access to the file.

In typical cases, you can simply click Submit to create the data connector, but there are some advanced options you can set as described in later sections.

Dragging an Access view to the dashboard canvas
Dragging an Access view to the dashboard canvas

Note
The same third-party driver is required on the Dundas BI server to connect to Excel and Access files. If you experience a connection error with the above steps, see the Excel Connection Issues troubleshooting article for a resolution.

4. Options

The following options are available for the Microsoft Access data provider.

4.1. Advanced

  • Extended Properties - Provider-specific connection information that cannot be described explicitly through standard properties.
  • Locale Identifier - The locale ID (LCID) specifies the database's collating order, which is the character set that will be used to determine how values in the database are sorted.
  • Authentication - The authentication method to use.

Advanced options
Advanced options

4.2. Jet OLEDB

  • Database Password - Required to open a password-protected database. 
  • Registry Path - The path to the registry subkey to use for Jet database engine settings.
  • Database Locking Mode - Specifies the mode used when locking the database to read or modify records.

Jet OLEDB options
Jet OLEDB options

4.3. Security

  • User ID - The user's ID (for user-level security).
  • User Password - The user's password (for user-level security)
  • System Database - Specifies the location of the Microsoft Jet workgroup information

Security options
Security options

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri