I am running into the problem where MS Access will only show the first 255 fields of an ODBC linked view. Of course the data I need resides in a field after 255. I have not been able to create a successful pass through query. Does anyone else have a solution for this issue?
Pass through example: SELECT Administrator_TRANSACTION.TYPE
FROM Administrator_TRANSACTIONS;
Get the error ODBC - called failed ...... Administrator_TRANSACTIONS not found.