Pyodbc Error - Python to MS Access

Question

I am running on Windows 7, Python 2.7 and Microsoft Access 2013.

When I try running:

import pyodbc
conn_string = '''
DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};
UID=admin;
UserCommitSync=Yes;
Threads=3;
SafeTransactions=0;
PageTimeout=5;
MaxScanRows=8;
MaxBufferSize=2048;
FIL=MS Access;
DriverId=25;
DefaultDir=C:\Users\jseinfeld;
DBQ=C:\Users\jseinfeld\Desktop\Databasetest1.accdb;
'''
connection = pyodbc.connect(conn_string)

I receive the following error message:

Error: ('HY000', "[HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x29dc Thread 0x113c DBC 0x8a3ed48    

Jet'. (63) (SQLDriverConnect); [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x29dc Thread 0x113c DBC 0x8a3ed48

Jet'. (63); [HY000] [Microsoft][ODBC Microsoft Access Driver] Not a valid file name. (-1044); [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x29dc Thread 0x113c DBC 0x8a3ed48 

Jet'. (63); [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x29dc Thread 0x113c DBC 0x8a3ed48

Jet'. (63); [HY000] [Microsoft][ODBC Microsoft Access Driver] Not a valid file name. (-1044)")

I realize there are many questions regarding Pyodbc and MS Access. I have already executed the following:

1) Ensured I have 64 bit Python and 64 bit MS Access

2) Given permission to the account access to the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC registry key

https://support.microsoft.com/en-us/kb/295297

Error in opening an Access database in python

"General error Unable to open registry key Temporary (volatile) ..." from Access ODBC

3) Tried to ensure I have a valid connection string https://stackoverflow.com/questions/6469545/python-connecting-to-a-database-with-pyodbc-not-working#=

4) The Access database is not open when I try running this code. I have re-booted my computer and am still receiving this error.

Please let me know if there is any other action I can try.

The way you build the connection string means that it includes embedded line breaks. Have you tried it without line breaks? ... starting from a raw string something like this: conn_string = r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\jseinfeld\Desktop\Databasetest1.accdb;' — HansUp
– HansUp, Commented Mar 23, 2016 at 14:24
Those "Not a valid file name." entries suggest that it might be a typo in the file path or perhaps a permissions issue. Have you tried copying the file to someplace like "C:\Users\Public\..." (and double-checking the file name)? — Gord Thompson
– Gord Thompson, Commented Mar 23, 2016 at 14:27
Also, I've never seen Threads= in an Access connection string. Suggest you combine Gord's suggestion with a simplified connection string ... starting with just the Driver and DBQ properties. — HansUp
– HansUp, Commented Mar 23, 2016 at 14:32
@HansUp I take back my last comment. I have tried conn_string = 'rDRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\jseinfeld\Desktop\Databasetest1.accdb;' but not conn_string = r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\jseinfeld\Desktop\Databasetest1.accdb;' Your first comment here solved my issue. Can you post it as an answer so I can give you credit? — BeeGee
– BeeGee, Commented Mar 23, 2016 at 14:42

HansUp · Accepted Answer · 2016-03-23 14:45:37Z

6

Start with a simple connection string with only the DRIVER and DBQ attributes and no embedded line breaks ...

conn_string = r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\jseinfeld\Desktop\Databasetest1.accdb;'

Once you get the simplest connection string working, you can add and test other connection attributes as needed.

answered Mar 23, 2016 at 14:45

HansUp

97.3k11 gold badges80 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gord Thompson · Accepted Answer · 2016-03-23 14:51:22Z

4

Additional to HansUp's answer, I use the following technique to build connection strings without embedded line breaks that are still easy to read by us humans:

conn_string = (
    r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};'
    r'DBQ=C:\Users\jseinfeld\Desktop\Databasetest1.accdb;')

answered Mar 23, 2016 at 14:51

Gord Thompson

125k39 gold badges252 silver badges458 bronze badges

Comments

Mohammed GADIRI · Accepted Answer · 2024-03-31 13:37:50Z

0

if you use just *.mdb you can build the connection like this: to avoid the error ODBC Driver not found.

db_main = f"C:\Users\jseinfeld\Desktop\Databasetest1.mdb"

conn_string = r"DRIVER={Microsoft Access Driver (*.mdb)};" \
   f"DBQ={db_main}"

edited Mar 31, 2024 at 13:37

answered Mar 31, 2024 at 13:36

Mohammed GADIRI

11 bronze badge

1 Comment

Gord Thompson Over a year ago

Note that this will only work for apps running under 32-bit Python (on Windows).

Collectives™ on Stack Overflow

Pyodbc Error - Python to MS Access

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related