Access Truncating Linked ODBC field names

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!
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top