R
Rick
When creating a query using a linked table which has over
500 fields only a portion of those fields appear to be
available (I'm assuming 255). I understand the Access
limit of 255 fields in a table or recordset. That limit
seems to apply to the linked table as well. Is there
anyway to see all of the fields in the linked table in
order to choose any of them to create a query which would
use fewer than the the 255 maximum?
500 fields only a portion of those fields appear to be
available (I'm assuming 255). I understand the Access
limit of 255 fields in a table or recordset. That limit
seems to apply to the linked table as well. Is there
anyway to see all of the fields in the linked table in
order to choose any of them to create a query which would
use fewer than the the 255 maximum?