Kevin, I was just researching this myself, and I found some interesting information about some changes in Access 2003. I don't know if Access 2007 behaves this way too, but here's what I found out:
Microsoft used to distribute MS Photo Editor with previous versions of Office (97, 2000, and XP). Apparently, they don't include it with Office 2003. MS Photo Editor is the "OLE Server Application" for images inside of Access. So, basically Access 2003 can't display images inside of forms that are Bound in the table like Access XP and 2000 could.
Real smart, Microsoft.
Anyhow... if you have an older version of Office, you can install JUST the MS Photo Editor component AFTER installing Access 2003, and that *should* fix the problem - although I haven't tested it myself, so I can't say for sure (this is just what I'm reading on various tech sites).
NOW... keep in mind that Access only behaves this way if you try to click and drag a file from the desktop (like I show in the lesson) or you try to Insert Object... the picture. You can, however, still display the picture properly if you COPY AND PASTE it from a graphics application.
For example, I just opened a JPG image in my web browser (either Internet Explorer or FireFox) and then I right-clicked on it and selected COPY. Then right-click on your OLE Object Frame in your Access Form and select PASTE. If came in just fine and displayed properly.
The same would work just fine if you opened up an image in MS Paint or even something like Photoshop. As long as you're copying and pasting a PICTURE and not a FILE, Access will display it just fine.
Very strange... but that's the deal.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.