Python Forum

Hello!!

I'm try to connect to a accdb Access database:

import pyodbc

conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\GCAMPS.TAX5600\Desktop\local.accdb;')
accesscursor = conn.cursor()
accessQuery = "SELECT * FROM peculiaritats"
accesscursor.execute(accessQuery)
r= accesscursor.fetchone()
print (r)

And I get this error:

Error:Traceback (most recent call last):
  File "C:\Users\GCAMPS.TAX5600\Desktop\prova.py", line 3, in <module>
    conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\GCAMPS.TAX5600\Desktop\local.accdb;')
pyodbc.Error: ('HY000', "[HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x2a10 Thread 0x2808 DBC 0x3beda44                                                              Jet'. (63) (SQLDriverConnect); [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x2a10 Thread 0x2808 DBC 0x3beda44                                                              Jet'. (63); [HY000] [Microsoft][ODBC Microsoft Access Driver] The database you are trying to open requires a newer version of Microsoft Access. (-1073); [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x2a10 Thread 0x2808 DBC 0x3beda44                                                              Jet'. (63); [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x2a10 Thread 0x2808 DBC 0x3beda44                                                              Jet'. (63); [HY000] [Microsoft][ODBC Microsoft Access Driver] The database you are trying to open requires a newer version of Microsoft Access. (-1073)")

Microsoft Access for Office 365 MSO (16.0.11629..20210) 32 bits

MS Access DB Engine 2016 32 bits

Python 3.7.3 32 bits

Pyodbc installed

Driver ODBC: Microsoft Access Driver (*.mdb, *.accdb)

Total permissions on HKEY_LOCAL_MACHINE\SOFTWARE\ODBC

Anyone can help me? Thx

The database you are trying to open requires a newer version of Microsoft Access
I'm not a huge user of MS windows, But you can probably update the access driver
Documentation is here: https://github.com/mkleehammer/pyodbc/wi...oft-Access
as stated, only works with .mdb, not with .accdb

There are other packages available, see: https://pypi.org/search/?q=MS+access

taxit

Larz60+