NoSuchModuleError: sqlalchemy-access

Question

I have a script that queries and updates an access table. I've used it successfully on my computer, but after installing anaconda and spyder on a different computer (same versions as the original installation on the original computer) it doesn't work on the new computer. To clarify: I installed the package using pip install sqlalchemy-access on the anaconda prompt, and when running pip list|findstr access I get sqlalchemy-access 1.1.3. However, when I run the script in spyder I get the NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:access.pyodbc error.

Answer 1

I don't know why, but after trying multiple times, I checked again (pip list|findstr access) and found that the installation of sqlalchemy-access, which I managed to find before in the anaconda prompt, has disappeared. I installed it again (for the third or fourth time) and now it works.

Answer 2

Do you have several different python versions on your computer?

Maybe installing the package with

pip3 install sqlalchemy-access

Could fix this.