I tried the procedure shown in this lesson but it didn't work. First I converted the JPEG via Painter into a .bmp file. The resulting file is big - 22.9 MB. When I tried to paste it into the box on the form (form view) I got this message: "MS Access can't read the OLE object because communication was interrupted. If the OLE server application is located on a network server, make sure your server is connected to it." Not sure what that means; my home computer is connected to a WiFi router and network. I also tried the other route: right click in the box --> new Access menu --> create from file --> browse, etc. But I got the same message. thanks, Nick
Reply from Richard Rost:
As I mentioned in the lessons, Access itself doesn't handle images. It relies on whatever your computer's default application is for that image type. You can determine what this is by double-clicking on an image file from Windows Explorer (or My Computer) and whatever app opens up the image is your default handler. Any time Access gives you that error message, it's having a hard time communicating with the handler app. You can try CHANGING that app by right-clicking on the image file and selecting OPEN WITH... Pick another program like Microsoft Paint or MS Photo Viewer. Sometimes other 3rd-party apps like Photoshop or even your web design editor can "take over" handling of JPGs and Bitmaps, which is bad.
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 6.