[AccessD] ADO CurrentProject.AccessConnection

[Borge Hansen]

Hi all,
On my Windows 11 (ARM) system I have Office365 installed on my laptop as a
VM (using Parallels on a M1 Apple Macbook).

As part of setting up an ADO recordset on a local table in the frontend I
am using the
CurrentProject.AccessConnection as the connection string.

This is working forever - currently on Windows10 with Access 365 64bit on a
lastest terminal  WIndows Server with Access 2016 32 bit.
But it is failing on WIndows 11 (ARM) with Office 365 installed.

Using an empty Access .accesdb file with the only other reference than the
default ones being
Microsoft ActiveX Data Objects 6.1 Library

I can successfully in VBA run in the immediate window
?CurrentProject.AccessConnection
And I get similar to this response:
Provider=Microsoft.Access.OLEDB.10.0;Persist Security Info=False;Mode=Share
Deny Read|Share Deny Write;Data
Source=C:\Users\Borge\Documents\bshADO_TEST.accdb;User ID=Admin;Data
Provider=Microsoft.ACE.OLEDB.12.0

On the latest Windows Server the reference to
Microsoft ActiveX Data Objects 6.1 Library
is held in C:\Program Files (x86)\Common Files\System\ado\msado15.dll

Similar on Windows 10 64 bit with Office365 64 bit, where the reference
location defaults to:
C:\Program Files\Common Files\System\ado\msado15.dll

On Windows 11 ARM in Access VBA the default reference is set to the same
C:\Program Files\Common Files\System\ado\msado15.dll

But I always get the run time error 429:
"ActiveX component can't create object"

On Windows 11 (ARM) there is also this folder with a msado15.dll version
C:\Program Files (arm)\Common Files\System\ado\msado15.dll
plus quite a number of other folder locations with a msado15.dll file

However
- I can't in Access VBA browse and point the
Microsoft ActiveX Data Objects 6.1 Library
to that folder and file.
- I cannot move the (arm) version of the msado15.dll file to the default
folder reference for
Microsoft ActiveX Data Objects 6.1 Library in Access VBA

I have reached a dead end!

Can anyone help spread some light on this - provide a solution?

Shane?

Thanks,
/borge