Access Truncating Linked ODBC field names

  • Thread starter Thread starter pa1971
  • Start date Start date
P

pa1971

Hello, I've created a link to an ODBC table in Access 2007. The table (or
view) has some field names that are too long, and Access has truncated those
names when creating the link. As a result, I cannot include those truncated
fields in a access query. I've tried overwriting the field name to the
complete version, but access does not recognize it. Is there a work around
for this issue? I've been told that the group that maintains the table will
not consider changing those field names.

Thank you!
 
I expect you could use the longer names in pass-through queries. These would
not be updateable but might provide increased performance.
 
Back
Top