MS Access database through ADO

[AleksP]

Hello!



Following software is installed:

1) Windows 8.1 64-bit, processor x64.
2) Office professional plus 10, 32-bit version.
3) Mathworks Matlab R2017b x64.

In order to open MS Access database through ADO the following code is used:

conn = actxserver('ADODB.Connection');
conn.CursorLocation = 'adUseClient';
conn.Open('Provider=Microsoft.Jet.O LEDB.4.0;Jet OLEDB:Engine Type=4;Password="";User ID=Admin;Data Source=G:\Database\1.mdb;Mode=Share Exclusive;Jet OLEDBatabase Password=xxx;Jet OLEDB:Encrypt Database=True');

Error message is retrieved after code execution:

Error using COM.ADODB_Connection/Open
Invoke Error, Dispatch Exception:
Source: ADODB.Connection
Description: Provider cannot be found. It may not be properly installed.
Help File: C:\WINDOWS\HELP\ADO270.CHM
Help Context ID: 12ee4f

I tried to install AccessDatabaseEngine_X64, but got the following error message.



Please, help to find the solution of the problem?

[isladogs]

You've already described the problem. You have 32-bit Access so can't install a 64-bit component.
But why are you trying to install the database engine at all? You already have it as part of Access

Why use ADO? If you want to connect your current database to an external database, just use the linked table manager to create linked tables.