
Problem With Memo Fields And DAO
Hi All,
I seem to be having problems when using DAO to update
memo type data in underlying table. Everything seems to
work fine and my users are able to update data up until
the number of characters exceed somewhere around 2000
characters. Once this threshold is exceeded DAO is
unable to update data (..using rst.update method). At
first, I suspected there may have been something wrong
with my data, but found that if I open the table directly
and pasted this exact same data directly into the memo
field, everything seem to work fine... if fact, I
continued to this and was able to reach the "advertised
maximun allowable" of 65,535 charaters for this type of
field.
Help in Access states that "...If the Memo field is
manipulated through DAO and only text and numbers [not
binary data] will be stored in it, then the size of the
Memo field is limited by the size of the database.)" But
I am not sure what is meant by the "size of the
database"... In my simple mind this would seem to imply
that you could hanlde more data using DAO...not less.
I would like to resolve this issue, since the data that
my users enter is partially generated by code onto a
temporary table (which contains a memo field in question)
and then copied over onto the destination table by
opening a recordset and using the rst.edit and rst.update
method.
Any help solving this will be greatly appreciated!
Thanks,
Frank