Microsoft Access Specific Configuration Settings
In the Layer2 Business Data List Connector the data source must be configured
as follows to connect to Microsoft Office Access.
Figure 1: Sample connection configuration to connect to MS Access via .Net
Framework Data Provider for OleDb
Please note the following about settings, features and possible issues
- Data Providers can be OLEDB
(preferred) and ODBC (both included in package)
- In both cases the Microsoft ACE OLEDB 12 provider (64-bit) must be
installed. More information here.
- The data source path can be both, local (e.g. C:\databases\mydb.accdb) or on
file share (e.g. \\myShare\databases\mydb.accdb). In both cases please make sure
that the database can be accessed from current user context. The user context is
the currently logged in user (in case of BDLC is used from the SharePoint UI) or
the timer service account (in case of scheduled background updates).
- You can use Access SQL to query, but only syntax that is supported by the
Microsoft data provider.
Do you have any issues to connect? Please contact [email protected] for next steps.