Memo field data lost on update

[rad2004]

Hope someone has come across this before, but I've found problems with memo type fields where the data has been lost or changed to what appear to be Japanese characters when they are included within an Update query!
Anyone know what I can do about this.

 

[vjh]

Can you be more specific???

vj

 

[rad2004]

I have a temporary table with the field 'Description' as a memo type field. Once the data has been updated by the user, an update query runs (called by code) and copies all of the contents of this temporary table (including this Description field) to another more permanent table.
(This is an update process because there is other essential and key information on the permanent table apart from that on the temporary table). My update query uses the key field, identical in both tables, as the link between the two.

On viewing the contents of the permanent table after the update, the Description contents have either been completely removed or have been replaced by what appear to be a few Japanese or Chinese characters.
NB the field data-types in both the temporary and permanent match so there is no data conversion.

This must be a known error as it seems so extraordinary!