Hi Al,
I know this behavior with MS SQL, ORACLE and etc. I use MDB file and ODBC driver truncate long string automaticaly without error message, but I have disable showing warning message.
Version ODBC driver is 4.00.6019.00 on my computer.
MartinJ
>>Hi Al,
>>
>>How is table structure in mdb file?
>
>Problem solved. It was a combination of:
>
>- Incomplete ODBC connection string
>- Some field sizes in the Access .MDB had changed from what the view expected. I think the ODBC error I posted earlier had something to do with trying to cram 150 chars into a 50 char field.