[johnsongilpp Contributions: 0Level 1☆]

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.
This is a cached copy. Click here to see the original post.

[chanarbon Contributions: 0Level 1☆]

Have you tried Administrator.TRANSACTIONS instead. It seems that the MS Access application does not find the mentioned table from the schema because of the naming. With the office applications connecting using ODBC, it normally uses dot notation of role and the table name.

[Author]

Posts