Bookmark and Share

Enter your email address:

Delivered by FeedBurner

Home Page

Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!

eXTReMe Tracker

  Sunday, August 17, 2008 – Permalink –

Pictures in Forms

It can still be done

Photo Editor was an Office component prior to Office 2003.

In Access/Office 2003/2007 MS Photo Editor was replaced, and Office no longer includes an OLE server for images.

To work around this issue, reinstall Photo Editor.

To do this, follow these steps:

  1. Insert the Microsoft Office XP CD-ROM into your computer's CD-ROM or DVD-ROM drive.
  2. If the Office XP Setup program does not start automatically, follow these steps:

    1. Click Start, and then click Run.
    2. In the Open box, type drive:\Setup.exe, where drive is the letter of your CD-ROM or DVD-ROM drive.

  3. Start to step through the Setup process, and then select Customize for the type of Setup to perform.
  4. When you reach the Selecting Features step, set each node of the Setup tree to Not Available.
  5. Under Features to install, expand Office Tools.
  6. Click Microsoft Photo Editor, and then click Run from My Computer.
  7. Click Install Now.
  8. Click OK when Office XP Setup has completed successfully.

Microsoft Support Article: 817095

Pictures in Access Forms & Reports
OLE Object Photo & Image Problems & Solutions

Handle/Display images in forms/database

"While it's possible to actually store the images within the database itself as OLE objects, normally it's not the preferred way. When you embed an OLE object in a table, you're storing a lot of overhead as well. This overhead is the information about the object (such as its parent application) that Access needs to store in order to render the object properly."

Displaying photos in a form

[Edited entry from 5/3/2005]

See all Topics


<Doug Klippert@ 3:50 AM

Comments: Post a Comment

Links to this post:

Create a Link