I am trying to link a MS Access database to a Lotus Notes database using notesSQL to link through ODBC. However, I can only retreive a maximum of 200 characters from each field. I have set the 'Max length of text fields' to various values, which does not have any effect.

Has anyone seen this before?