I am using Access 2010
I need to store pictures of a product in my database. The product will have multiple pictures.
I thought of using an "Attachment" field to do this. On a form this works great, but on a report only one picture is displayed / printed!
How do I get all the attachments to print?
On a form, what should the "Default Picture Type" be? Linked, Embedded or Shared?
Reading this forum there is debate about the pros & cons of using attachments.
Should I be using the "Attachment" data type or should I go back to storing the text of the files path in a text field?
I do need to display the graphic on the form. This I can do using an "Image". But this tends to bloat the database. What is the best method to adopt to minimise the bloat?
Thanks
I need to store pictures of a product in my database. The product will have multiple pictures.
I thought of using an "Attachment" field to do this. On a form this works great, but on a report only one picture is displayed / printed!
How do I get all the attachments to print?
On a form, what should the "Default Picture Type" be? Linked, Embedded or Shared?
Reading this forum there is debate about the pros & cons of using attachments.
Should I be using the "Attachment" data type or should I go back to storing the text of the files path in a text field?
I do need to display the graphic on the form. This I can do using an "Image". But this tends to bloat the database. What is the best method to adopt to minimise the bloat?
Thanks
