VBA Query fails if Attachment field is present

[pbassett]

My query fails with "Invalid Operation run-time error -2147467259 (80004005)". It only fails when an Attachment field is in the table.
The query runs correctly when I remove the Attachment field so I'm sure its mere presence is the cause.
Is anyone aware of this? My first though is to create a separate Attachments table, but now I can't figure out how to add the Attachment as a subform. The Attachment wizard doesn't display the Attachment field as an available field. I'm sure I can display the attachments so any help is appreciated.

 

[Micron]

Perhaps you have uncovered another reason to not use attachment fields in an Access table, but it does sound bizarre if you're saying the mere presence of the field in the table causes this. As I read your post, the field is not part of the query at all. Yet I can't imagine why you'd want the attachment to appear in a subform. AFAIK, it can't anyway (unless these are images, and you're not saying), and the fact you're asking makes me think that maybe you do have it in your query. Why else would you want the attachment to "appear" on a form if it wasn't?

Many experienced developers won't/don't use attachment fields. Instead, a field for file paths is used, and if the attachment is an image, an image control handles the display, getting the image according to the image file path for each record. Attachment fields cause rapid db bloat and can quickly lead to reaching the maximum GB size for a table.

 

[pbassett]

It works when I use DAO instead of ADO.

 

[Micron]

So you're creating sql in code. Your thread title and post made no mention of that; just that it was a query. ADO appears to be possible for this but can be more difficult. ADO didn't turn out to be the greatest thing since sliced bread. M$soft doesn't advocate for it so much any more.