Link to home
Start Free TrialLog in
Avatar of bootsb156
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?
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Yes, if you want to publish/View these images on a web service, they need to be in the Attachment datatype.

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
Avatar of bootsb156
bootsb156

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.
<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?
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
ASKER CERTIFIED SOLUTION
Avatar of puppydogbuddy
puppydogbuddy

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you for your assistance.