read access file (mdb) with pyodbc error in ubuntu

Question

I would like to read an access file (mdb) with pyodbc. The code is supposed to be very simple:

import pyodbc 
DBfile = './test.mdb'
conn = pyodbc.connect('DRIVER={Microsoft Access Driver (*.mdb)};DBQ='+DBfile)

where the python script and the mdb file are in the same folder. However, I get the following error:

Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'Microsoft Access Driver (*.mdb)' : file not found (0) (SQLDriverConnect)")

where am I wrong?

thanks a lot for any kind of help.

Resolve the current folder (`./`) and assign `DBfile` the full path. — Gustav, Nov 20 '21 at 15:27
Then your script probably hasn't been granted rights to the file. — Gustav, Nov 20 '21 at 16:05
It can be open without problem in access and the error says 'file not found (0)' — diedro, Nov 20 '21 at 16:07
But Access is not your script and ODBC driver. Your error is typical for missing rights to a physical file known to exist. — Gustav, Nov 20 '21 at 16:12
if I change the permission with sudo? I can read it with DBeaver. — diedro, Nov 20 '21 at 16:20
I guess so, but I have no experience with Python or its ODBC library. — Gustav, Nov 20 '21 at 17:22

score 0 · Answer 1 · answered Nov 20 '21 at 17:41

0

Next, check that you have the correct 32- or 64-bit driver installed.

answered Nov 20 '21 at 17:41

Gustav

1 Answers1