append attachment to another table

[nicolareina]

hello forum how do I append attachement in another table with vba?



running the query gives me this error.


help me please!!!

My project
esempio.zip

[Welshgasman]

Attachments use Recordset2
Not having used attachments, I would probably add via a recordset if it balks at the query method, though you have not shown your sql code?

So just a guess really.

For other members the message appears to be as attached when I tried it.
Presumably you would need to add all three subfields?

Might be better just to add the key for that record and attachment in some way?

[moke123]

I would guess you need a record set to do it. I don't use them either.

Are you aware of the pitfalls in using attachment fields? Suggest you google it.

[June7]

Review https://learn.microsoft.com/en-us/of...chments-in-dao and https://www.access-programmers.co.uk...hments.169056/

Attachment field is a type of multi-value field but has to be treated differently because data is coming from drive location.

Also Review https://www.devhut.net/adding-attach...cess-database/

[mike60smart]

Hi Nicola

As suggested by other Forum Members, I would not use attachment fields but use another related table to store the FilePath to
the specific Documents associated.

[Gicu]

If you insist in your original quest please have a look at this link from theDBGuy with a sample showing you how to do it:
http://www.accessmvp.com/thedbguy/de...attachment.php

Cheers,