Updating records with attachment fields

[hertfordkc]

I maintain a 9 year old database which I recently converted to Access 2007. While doing so, an attachment field was added to one of the tables.
My problem: I recently gathered some data in the attachment fields in the development copy of the database and wanted to transfer the additions to the production table. The update query came back with a message to the effect that you can't use an attachment field in an update query.


Has anyone else encountered this problem? If so, what is the workaround? VB or manual re-entry of the data?
Thanks for any info.

[June7]

Review this thread https://www.accessforums.net/access/...t-15815-2.html

You can skip down to post 18 if you want.

[hertfordkc]

My patience ran out in doing searches. Since my problem involves limited data, I think I'll do a manual transfer, but now I know what I'm up against if I need to do more with the attachment field type.
Thanks again.