enaio® capture: Microsoft Access Database Engine 2016

This information is updated periodically as soon as our analyses deliver new findings. Please check back periodically.

Microsoft Access Database Engine 2016 / enaio® database synchronisation

Microsoft Access Database Engine 2016 is integrated into the enaio® capture subprogram enaio® database synchronisation.

Microsoft Access Database Engine 2016 has been discontinued. Install the M365 Access Runtime instead. The M365 Access Runtime is installed via the MS Office setup. Please also note the information at MS 365 Access Runtime.

Afterwards, adjust the connection string in your configuration file.

enaio® capture: enaio® database synchronisation

Required adjustment of the connection string:

Previous valueNew value

Case 1 — .accdb with ACE 12.0

Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=C:\daten\db.accdb

New provider: ACE 16.0

Provider=Microsoft.ACE.OLEDB.16.0;
Data Source=C:\daten\db.accdb

Case 2 — .mdb with Jet 4.0

Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\daten\db.mdb

Update the provider and file format

Provider=Microsoft.ACE.OLEDB.16.0;
Data Source=C:\daten\db.accdb

The existing .mdb file must be converted to the new .accdb format before making this change. The file extension in the connection string must be adjusted accordingly.

Affected versions

enaio® capture: enaio® database synchronisation 12.0, 11.10