Forum Discussion
“Operating system is not presently configured” error with Access ODBC
This looks like a "closing in" issue. I would take the next steps to solve or narrow down the problem:
- Run it on another machine and see if the problem occurs.
- Check for recent Windows and Microsoft Office updates and roll them back if possible.
- Remove my Microsoft Office installation and install it again.
- Remove the Microsoft Access Database Engine Redistributable and install it again.
- Try to update pyodbc: pip install pyodbc --upgrade
- Try an alternative Python package for connecting to Access. For instance: pypyodbc (https://code.google.com/archive/p/pypyodbc/ ).
Options 5 and 6 are merely solving the symptoms (if they work), rather than solving the problem. But if they fixe the issue, they could save the day.
Good luck and best wishes,
Tieme
Woldman I had done all the things of installing and uninstalling the microsoft office, python or pyodbc and sqlalchemy libraries but it didn't work. But my main problem was solved when I removed Microsoft Access Database engine driver and put the latest version on my pc.
Thanks for the help
https://stackoverflow.com/questions/63957789/operating-system-is-not-presently-configured-error-with-access-odbc/63963079#63963079
- Sep 22, 2020
Hi,
I'd say your solution is essentially no 4 on Tieme's list.
This is a hiccup in the Breaking ACE out of the bubble works and should get fixed with one of the next O365 updates. Until then, the workaround is to reinstall the 2016 Redistributable in order to have the ODBC driver working again.
Karl
*********
http://AccessDevCon.com
http://donkarl.com