Excel ADO connection problem with Excel 2010 on Win11

I am using Excel 2010 on my new Windows-11.

My problem is; the below simple ADO code returns an error saying that;

"'Method Properties' of object '_Connection' failed"

on line "adoCN.Properties("Data Source") = myFile"


Before this line, no errors encountered so both of the adoCN and RS objects are created.

Please Login or Register  to view this content.

The file is located in C:\TestFolder and executed as an Admin and also as a standard user but, nothing changes...

Also, none of the ADO related VBA codes are not working which were working on Excel 2010 / Windows-7

I guess something is going wrong with Win11 but i am not sure.

Is there anybody having a similar problem on Windows11 ?

Note: The same question is also posted on Stack Overflow in the link given below;

https://stackoverflow.com/questions/...nect-to-a-file

@Poizhan, thanks for your message but I've to say that; the code was working without any problem with Excel 2010 on Win7 before.

I am working with Excel and VBA applications for more then 25 years.

The problem arised when i bought a new laptop with Win11 and installed my Excel 2010.

Probably, there is a problem with ADO drivers...

Except the mentioned ADO problem, everything seems to be working with my old Excel files on Win11.

@Jindon, thx for your message.

I've tried the JET drivers before and got the same error as well. (I tried your code again but no hope... same error)

Also, i tried to connect to a MDB file instead of an Excel file but i got same error...

Btw, are you on Win11?