Multi-Valued Field Query problem

[Jimmy Jones]

Hi,

My problem is that I cannot run make-table-query with "attachment " field...

Is there any workaround? I need to find a way to move attachments between tables together with regular data.

Regards,
Jimmy

[NeoPa]

If I had any idea what you were referring to when you say Attachment, I may be in a position to help.

That first post with the question in is so important. It's a shame to waste it by posting before it makes clear sense.

[hype261]

NeoPa,

In Access 2007 Attachment is a data type for a table.

[NeoPa]

Thank you.

Maybe I should butt out of this one now then. It's clearly not within my experience to help.

[colintis]

During my search I found there's actually 2 questions in this post.

1. How to create Make-Table query with the attachment data type
2. How to move around the attachment data between tables

So for your first question. The data type within the query is simply as below

CREATE TABLE xxx(<other field names>. [B]picture, Attachment[/B])

There's nothing else other than defining that field is attachment as data type.

For the second question, most people work around this by using the DAO, even Micro$oft have references with using DAO as well. Here are some link, link, and link for you to look at.

It may also take some time to debug if there's any errors, good luck. ;-)