Microsoft Access database engine cannot find the input table or query

Question

I'm trying to establish connection with Microsoft Office and to run a query but it is showing error

Here is my code:

import pyodbc

conn = pyodbc.connect(r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=E:\Python\Database\att2000.accdb;')
cursor = conn.cursor()
cursor.execute("SELECT CHECKINOUT FROM att2000 Where CHECKTYPE = O")

for row in cursor.fetchall():
    print (row)

Here is the error:

Error is occurring while executing the query
----> 5 cursor.execute("SELECT CHECKINOUT FROM att2000 Where CHECKTYPE = O")
      6 
      7 for row in cursor.fetchall():

ProgrammingError: ('42S02', "[42S02] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine cannot find the input table or query 'att2000'. Make sure it exists and that its name is spelled correctly. (-1305) (SQLExecDirectW)")

att2000 is the name of the database file. Apparently it does not contain a table or view that is also named att2000. Open the database in the Microsoft Access UI and verify what the table/view names are. — Gord Thompson
– Gord Thompson, Commented Dec 11, 2020 at 12:27

Gustav · Accepted Answer · 2020-12-11 13:11:48Z

0

I guess you mix up the file name and the table name.

Try:

cursor.execute("Select * From CHECKINOUT Where CHECKTYPE = O")

answered Dec 11, 2020 at 13:11

Gustav

56.4k7 gold badges33 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

Microsoft Access database engine cannot find the input table or query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related