Access Dashboards | Microsoft Access database as source
You can connect the Dashboard to MS Access using the ODBC and defining the DSN source. This method is described in this section Access Dashboards using ODBC and DSN
Within InfoCaptor, you can connect directly to the access mdb file without the need to define the ODBC Data source name (DSN)
Let say your access mdb file is located in this directory
C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb
And you want to connect to this file and create dashboard against it.
First format the above directory location by replacing the “\” (backward slash) to “/” (forward slash)
so your directory path string should be like below
C:/Program Files/Microsoft Office/Office/Samples/northwind.mdb
Now open the connection window in InfoCaptor and enter the information as shown below
- In the Driver, select “MS Access .mdb - sun.jdbc.odbc.JdbcOdbcDriver”
- In the Connect Name, type any descriptive name so that you can identify the connection by this name
- In the connection url enter [ C:/Program Files/Microsoft Office/Office/Samples/northwind.mdb ]
Clear all remaining fields and click on the connect button
Once connected, you can follow the Build Dashboard from Scratch tutorial.
One of the queries for northwind database is as below
You can download this sample Northwind Dashboard for reference.
I
