I have an ODBC connection that works fine through excel, I can connect to any table I want and see the data.
However, when I try to link a table in access, I always get an error:
The operation failed. There are too many indexes on table “FOO”. Delete some of the indexes on the table and try the operation again.