For this type of data Access Recordsets provide a GetChunk/AppendChunk method so you might find you need to use either the recordset interface rather than ODBC.

If your problem happens when overwriting data you may find it works if you blank the field first as the AppendChunk (which is probably being called by the Jet Engine) does an append... try updating it to Null first.