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.