Linked table works just fine.

Linked view (correctly created in ODBC environment with a Create View statement) comes across with all text fields as field size = 20.

This works fine for fields under 20 in length, but it truncates fields over 20 characters in length, like email and address.

What can I do? Is SERVERMAX set to 20 somewhere? Or is there a LPRECISION bug in Access 2000's ODBC handling? I need many linked views. Processing is too slow to handle this with append queries.


Thanks!