During my search I found there's actually 2 questions in this post.
- How to create Make-Table query with the attachment data type
- 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>. 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. ;-)