By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,678 Members | 2,021 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,678 IT Pros & Developers. It's quick & easy.

Multi-Valued Field Query problem

P: 10
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
Dec 15 '10 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,276
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.
Dec 16 '10 #2

100+
P: 207
NeoPa,

In Access 2007 Attachment is a data type for a table.
Dec 16 '10 #3

NeoPa
Expert Mod 15k+
P: 31,276
Thank you.

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

100+
P: 255
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
Expand|Select|Wrap|Line Numbers
  1. CREATE TABLE xxx(<other field names>. picture, Attachment)
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. ;-)
Dec 17 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.