Connecting to Access

Contents[Hide]

1. Overview

This article shows you how to connect to Microsoft Access (MDB/ACCDB) database files.

2. Drag and drop an Access file

The easiest way to work with an Access file is to drag it from Windows Explorer and drop it directly onto the Dundas BI Explore window or the dashboard canvas.

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

3. Connect to Access file

The following walkthrough shows you how to manually create a data connector for an Access file.

To begin, go to the main menu, click New, and then select Data Connector.

In the New Data Connector dialog, click inside the File Name box. Enter a name for your data connector.

Click the Data Provider dropdown and choose Access and DBF.

Set up a new data connector
Set up a new data connector

Click the Authentcation dropdown to choose an authentication method. For example, set it to Specified Windows credentials and enter your domain, username, and password on Windows.

Next, specify the Access file you want to connector to by using one of these options:

  • Click Choose File and use the file selector to select the Access file.
  • Or, use the UNC Path option to specify the full network path to the file. Example: \\server1\shared\MarketData.mdb

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

In typical cases, you can simply click Submit to complete the data connector and perform the initial discovery. But there are some advanced options which you can set as described in a later section.

To use the data connector, create a new dashboard and then go to Explore. Locate and expand your Access data connector. Drag a native structure (e.g., view or table) to the dashboard canvas to see its data.

Drag an Access view to the dashboard canvas
Drag 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 Access and DBF 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: 7am-6pm, ET, Mon-Fri