16 didn't work either. Same error message.
16 didn't work either. Same error message.
OK, one more. You never actually said that the code fails on the posted lines; just the error message and what you've used to try to fix it.
- Is it vba code and does it fail on that line? If not, you should post the code.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Data\Database1.accdb;
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.