We are running Access 2007.
We are able to update an MDB format version of the database in question.
We created a new ACCDB database and imported all queries/tables/etc from the MDB. We deleted and relinked all ODBC tables with keys defined.
The same make-table query now bombs with an ODBC call-failed message ("SQL data type argument out of range (#30030)".