I gave up on using the ACE connection string and instead used
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\mydatabase.mdb"
which worked with my 32bit app with a 64 bit access. It also worked on a test 64 bit app with a 32 access.
Don't understand why this has been so difficult.