I am running into a Jet limitation that prevents me from accessing more than 255 fields in a table or query. I have the data stored on a SQL server and there isn't a limitation there. However, when I look at the linked Table in Access, I see only the first 255 fields. I'm told that this is not an Access limitation, per se, but a Jet Database Engine limitation. Is there a way I can bypass Jet in my forms and go directly to the SQL Server using ODBC somewhere in the Record Source property, perhaps?

I'll be happy to use VBA to do this if that is an option.

By the way, cutting back the number of fields or creating separate, smaller queries based on the need, isn't a viable option.

Thanks, Eddie