Moving records with attachments from one table to another

[K]

How do you move attachments, either by query or programmatically from one
access 2007 table to another. Everyone points to how to load from file or
save to file. I want to update from current It's already in the database
I now need to move it to another table within the database.

 

[Pieter Wijnen]

Insert Into query (aka Append Query) Or Select into Query (aka Make Table
Query)
Optionally followed by a Delete Query ???

Pieter

 

[Tom Wickerath]

Hi K,

See this blog posting, by Access MVP Oliver Stohr:

August 2007 - Another example of working with the Attachment DataType
http://www.access-freak.com/blog.html#BlogEntryAugust200705


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________