Note: the other query that seems to be failing is a table with a Yes/No field. So my question is are there changes in the way SQL is parsed in Microsoft Access Database Engine 2016 and should I simply get customers to install the 2010 version? I did look for some release notes/breaking changes but couldn't find anything. It seems that something is different in the Access Database Engine 2016. What I don't understand is if I install the Access Database Engine 2010 then all works as expected. Most noticeably ones that use LIKE '%somevalue%' - now I understand that % is ANSI-92 but it's been working fine as I say so assume that's ADO related (I could change this to ALIKE I guess).

In general everything works OK but certain SQL queries are failing. So I grab Microsoft Access Database Engine 2016 Redistributable and install it. I have converted it to 圆4 and I believe I need to install some form of Access drivers no matter if the host PC has 圆4 Office installed or not. Using ADO in C++ on a PC with no Office installation.

I have an app that's been working fine in 32 bit using the connection string: Driver= Dbq=MyDatabase.mdb