Forum Discussion

willregex's avatar
willregex
Copper Contributor
Oct 13, 2026

MS Access ODBC driver doesn't support SQLPrimaryKeys function

I'm writing a python script using pyodbc to read an MS Access database. I was hoping to read the primary key of each table, but I'm getting the error IM001 "Driver does not support this function (0) (SQLPrimaryKeys)". Is there another way I can check the primary keys with python?

No RepliesBe the first to reply