Access Truncating Linked ODBC field names

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

 

[Duane Hookom]

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

 

[TallTed]

Hello, I've created a link to an ODBC table in Access 2007. The tabl
(or
view) has some field names that are too long, and Access has truncate
those
names when creating the link. As a result, I cannot include thos
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 wor
around
for this issue? I've been told that the group that maintains the tabl
will
not consider changing those field names.

You might try using a different ODBC driver. Sometimes, Access ask
the ODBC driver (which is supposed to ask the target DBMS) how long it
identifiers (catalog, table, and field names) can be -- and the driver
or even the DBMS, gives the wrong answer.

This can happen if your ODBC driver isn't version-matched to the targe
DBMS server, among other causes.

You didn't say what your target DBMS is, but my employer, OpenLin
Software, makes 'several drivers' (http://tinyurl.com/yd4mvvg) you ca
try free for 2 weeks.

Hope that helps!

Te