Attachment Field Images Fail After Compact and Repair?

[DavidJMancini]

I have a subform (continuous forms) that pulls data from a query, which pulls data from two tables that are in a one-to-many relationship. Basically, one table lists documents (many-side), and the other table lists document types (one-side). In the type (one-side) table, there is an attachment field called TypeImage; each record there has ONE .png image attached - the icon for that document type.

The (sub)form is set up with an image control to display the type icon for each document. The image control's Control Source is set to the TypeImage field. Now, when I first set it up, each record in the subform displays the correct icon just fine. But, when I do a compact and repair, the image control stops displaying the images from the attachment field... forever. I have to actually delete the TypeImage field, delete the image control, and literally recreate both from scratch to get it working again... only to be broken again when I do a compact and repair.

I see NO reason for this. :banghead:

EDIT: Note - the tables are not "actaully related" in the backend; I use "one side" and "many side" to describe what is going on in the query; technically i didn't make a relationship in the Relationship Editor.

 

[The_Doc_Man]

Let's clarify something. Are these "attached" .PNG files actually embedded in the database? Or do you use an external file and load the dev:/path/name.type specification for the control's .Picture source? (I recommend the latter treatment.) Since you have a BE file, you can just put the .PNG files there because you know you have access to the BE. If you have an external reference, it is just a text string that gets loaded to a control property, perhaps during the form's "OnCurrent" event. I would find it really hard to imagine losing THAT kind of reference to a compact & repair.