Jun-17-2019, 01:10 PM
Hello!!
I'm try to connect to a accdb Access database:
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
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 bitsMS 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