bootsb156
asked on
Access 2010 Attachments display blank fields
I am using an access 2010 database to display photos, name, etc. The photos won't display unless I use OLE object as the data type for the field and store the photos as "bitmap" images. This would be a good work around except that now, I need to publish the database to the Web and it is complaining about the field type and saying that I should use "attachment" as the field type which only shows blank fields instead of the photos. Can anyone help with this?
ASKER
Thank you for your esponse. The ole files are stored in the database in a field. At first, the photos were "jpg's," they were in another directory on my hard drive. Those just did not show up at all. Then, I did some research and discovered the OLE object data type as a workaround. Then, I was able to save the photos in bmp format and that worked. However, when I tried to publish the database to the Web, I got a message saying that OLE data types are not accepted and to use "attachment" as the data type. The attachment is always blank. How do I make the attachment work?
Currently, there are three images so reloading them would not be a problem except, it just doesn't work. I am also checking for patches and updates. I just thought of this.
Currently, there are three images so reloading them would not be a problem except, it just doesn't work. I am also checking for patches and updates. I just thought of this.
<The attachment is always blank. >
Define "Blank"
Are you saying that if you use the dialog box provided, you can select a file and inset it, but then it does not display in an Access form.
Or is it not appearing in the web page..?
Or are you saying that you can never actually insert the image into the field?
Define "Blank"
Are you saying that if you use the dialog box provided, you can select a file and inset it, but then it does not display in an Access form.
Or is it not appearing in the web page..?
Or are you saying that you can never actually insert the image into the field?
ASKER
I have not uploaded to the Web yet. When I insert the image into the table as an "attachment" it shows up blank. It won't display in the access form.
This works just fine for me:
Database143.accdb
Database143.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your assistance.
You did not state if these ole files were stored in the db or Linked...
OLE satnds for: (O)bject (L)inking or (E)mbedding
If the images are embedded, the you will need to extract them to a disk file, then load them back into Access to an Attachment data field.
See this utility:
http://www.lebans.com/oletodisk.htm
If they are linked, then you will still have to bring them into the db into an attachment field.
Sorry, I don't know of a way for this to be done in a "batch" automatically.
So keep this Q open for a while more for other experts to chime in.
JeffCoachman