Limit number of fields returned by ODBC table

[jwol]

Hi all, I've searched this with no success.

I have a ODBC (Firebird) table linked using a DSN connection which has >300 fields. In Access, the linked table only show 256 fields (max for Access). Otherwise the link works fine. I have no control over the source Firebird table.

What I'd like to do is limit which fields from the Firebird table are shown in Access. I don't need all the fields, but I need some that are at the end and are not linked in the current setup.

I'm very much a novice at using ODBC, but can I somehow use SQL or some other method to specify which fields to show in the linked table?

Thanks for any suggestions,
John

 

[KeithG]

Yes you need to use a pass through query. Create a new query with no tables and on the Menu bar goto Query=>SQL Spefic=>Pass Through You should now be in SQL view. Go into the queries properties and set the connection string. Now you will be able to write your sql statement to connect to your db.

 

[jwol]

Thanks Keith, worked like a charm!

I've wondered what a Pass Through Query was, now I know.
You saved me a lot of screwing around, thanks again.

John