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?
Microsoft AccessOffice ProductivityImages and Photos

Avatar of undefined
Last Comment
bootsb156

8/22/2022 - Mon
Jeffrey Coachman

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
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.
Jeffrey Coachman

<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 started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
bootsb156

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.
Jeffrey Coachman

This works just fine for me:
Database143.accdb
ASKER CERTIFIED SOLUTION
puppydogbuddy

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
bootsb156

ASKER
Thank you for your assistance.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.