Microsoft Access Specific Configuration Settings
In the Layer2 Cloud Connector the data source or destination entity must be
configured as follows to connect to Microsoft Office Access.
Fig.: Sample data entity
configuration to connect to Microsoft Office Access.
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
must be installed. It must fit to the Layer2 Cloud Connector architecture
installed (32- or 64-bit). 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 the Layer2 Cloud Connector Connection
Manager is used) or the service account (in case of scheduled background
Do you have any issues to connect? Please contact [email protected] for next steps.