I am developing an ms/access database that needs to store images (simple JPEG, around 50K each. In total, we expect to have a maximum of 500 - 700 images, so I am thinking to use OLE or attachment fields and embed.
The images are stored in files.
Can anyone help me and let me know
1. should I go to Attachment or OLE?
2. how to set up the field so the existing file will be incorportated
3. how to show the file on (i) screen and (ii) report
any help will be greatly appreciated
PS. I am ready to buy an Active X that helps me