On a previous post I wrote a little example of how to connect to a MS Access database using #Python, but when testing on #Windows7, I got a nice and unexpected error: the provider is not installed.
Error on MS Access y Python
One of the possible reason of this error is the mess of having Windows 7 64 bits, also the 32 bits version of MS Office 2007, and Anaconda 64 bits, and … of course, a mess also for Microsoft Windows, and … an error raised!
Downloading the drivers
The reason of the error is not having the right drivers intalled, so … let’s download Microsoft ACE drivers 64 bits drivers. I install it, but also, I receive another nice message:
Error when installing Microsoft ACE drivers
Another error!! That’s not good!
I verifyed that I’m not the one that has suffered this problem, so, I got the solution here, and one solution is to install Microsoft ACE drivers on passive mode, using the command line from MS-DOS and with this command:
AccessDatabaseEngine_X64.exe /passive
Passive install of Microsoft ACE Drivers
I have no time to see what’s happening during the installation, but … I go back to my exaple, run the code and ….
script running
Another problem solved!