Error in opening an Access database in python

Question

I am a new to python programming and i want to write a python program to read and write data to and from the database.

The connection code is as follows:

DNS='catalog'
DRV = '{Microsoft Access Driver (*.mdb)}'
conn = pyodbc.connect('DRIVER=%s;DSN=%s;' % (DRV,DNS))

catalog is the DSN name.

I am am getting the following error:

Traceback (most recent call last):
File "C:\Python27\exampes\xxx.py", line 8, in <module>
conn = pyodbc.connect('DRIVER=%s;DSN=%s;' % (DRV,DNS))
Error: ('01000', "[01000] [Microsoft][ODBC Microsoft Access Driver]General Warning  Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x12b4 Thread 0x1544  DBC 0x567ea4 Jet'. (1) (SQLDriverConnect);
[01000] [Microsoft][ODBC Microsoft Access  Driver]General Warning Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x12b4 Thread 0x1544 DBC 0x567ea4 Jet'. (1)"

Can anyone please help me..?

@Gord Thompson : I wonder how can a question asked two years ago could possibly duplicate of a question which was asked 7 days ago ?? — heretolearn
– heretolearn, Commented Oct 14, 2014 at 15:00
I was trying to point future readers to a more complete answer to this question. (See my comment to the answer.) I have reopened the question. — Gord Thompson
– Gord Thompson, Commented Oct 14, 2014 at 18:39

Jirka Hanika · Accepted Answer · 2012-07-13 15:45:29Z

2

The account under which you are running is not an administrator. It needs registry access as per the message (also described here)

Registry access is needed to find the ODBC driver for MS Access.

answered Jul 13, 2012 at 15:45

Jirka Hanika

13.7k3 gold badges52 silver badges80 bronze badges

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

1 Comment

Gord Thompson Over a year ago

For future readers: This is only one possible cause of the error message, and a relatively uncommon one at that. Other causes and solutions are outlined in another answer here.

Henrique Schumann · Accepted Answer · 2018-05-30 13:53:02Z

0

try to uncheck Attributes: Read-only box in file properties.

answered May 30, 2018 at 13:53

Henrique Schumann

13 bronze badges

Collectives™ on Stack Overflow

Error in opening an Access database in python

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related