I am having difficulty copying blob and memo fields from one a field in one table to another. Normally I use local SQL to manipulate my database tables, but I haven't found a statement that will let me update blob or memo fields. I usually get an error stating the capability is not supported.

For reference my statements look like this:

UPDATE "\\SERVER\Folder\Table.db"
SET Blob = (SELECT ADifferentBlob FROM "\\SERVER\Folder\ADifferentTable.db")
WHERE TableID > Value

I would prefer to make the change through SQL instead of writing an app if possible.