Hello,
My problem has to do with how to connect to an accdb database that has a default encryption from 32 bit Microsoft Office Excel 2016. My current connection string is
"Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\dataBase.accdb;Uid=Admin;Pwd=password;"
This connection string works when the database is not encrypted on both 32bit and 64bit MS office Excel. It also works on 64bit when it is encrypted with the default encryption.
However, when run on 32 bit with the default encryption I get the following error message:
"[Microsoft][ODBC Microsoft Access Driver] General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x5f08 Thread 0x2f94 DBC 0x256dbea4".
From what I've read switching to a legacy encryption will likely solve the problem however, I believe my companies group policy object is currently preventing me from doing so and having it changed would be troublesome. So before I go down that route I am looking for alternative solutions or other possible causes for this issue.
Thanks,
Casandra
Bookmarks