Hello everybody. I need to link some tables and views from Notes db to Access db, importing them as linked tables.The problem is that I need to work with a rich text field that may contain, let’s say, more than 2000 char. So I set up the ODBC source this way:
-
max length of text fields: 254
-
max length of rich text fields: 4096
The field I need to work with is the only one rich-text-type, so It should work, it should create all the fields with a maximum length of 254 and the rich text one of 4096 char. But it doesn’t work: also the rich text one is imported with a maximum length of 254 char. It seems like while connecting to the Notes db, the ODBC source ignores the fact that the field is rich text type, or the 4096 limit…
If a field is text type, it can not exceed 254 char in Access… But I read on a forum that setting up the max length to 4096 should force the conversion to Access “memo” type…