OLE Object Issue

[Roger]

I am running Access 2003

I'm trying to set up an Employee database with all pertinent data on each person. The database is not that large in terms of records (less than 90 records)

For each employee I want a pic of that employee

So I set up an OLE Object field in the table to accomplish this

I chose to use the LINK aspect so that the pictures are linked to a location on my hard drive

I edited all of the pictures in a graphics program to make them small in size

The problem, which is the reason for my question here: every time I try to load the pictures into the OLE object field in the table I'm getting the message: "A problem occurred while Microsoft Office Access was communicating with the OLE server or ActiveX Control. Close the OLE Server and restart it outside of Microsft Office Access. Then try the original operation again in Microsoft Office Access

I've tried making the pics smaller
I've tried using .bmp as well as .jpg
I've created a new database thinking there might be some strange corruption issue
I've tried loading the pictures into the table via a Form
Problem is the same no matter what

Has anyone seen this problem and if so can you help provide me a fix?

 

[Roger Carlson]

The usual solution to storing pictures as OLE object is to NOT store them in
the database as OLE objects. <grin> A better solution is to leave the
pictures as files in a directory and just store the PATH to the file in the
database. Then you can load the picture into a form or report at runtime.

On my website (see sig below) is a small sample database called
"Pictures.mdb" which illustrates how.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

I am running Access 2003.

I'm trying to set up an Employee database with all pertinent data on each

person. The database is not that large in terms of records (less than 90
records).

For each employee I want a pic of that employee.

So I set up an OLE Object field in the table to accomplish this.

I chose to use the LINK aspect so that the pictures are linked to a location on my hard drive.

I edited all of the pictures in a graphics program to make them small in size.

The problem, which is the reason for my question here: every time I try to

load the pictures into the OLE object field in the table I'm getting the
message: "A problem occurred while Microsoft Office Access was communicating
with the OLE server or ActiveX Control. Close the OLE Server and restart it
outside of Microsft Office Access. Then try the original operation again in
Microsoft Office Access"

 

[Roger]

Thanks for the help. Since i was using links to the pictures on my HD I wasn't aware that linking was the same thing as actually embedding the files into access causing it to Bloat

I reviewed your sample database and tried to incorporate your code

Here's what really strange though...

Say I open the database right now. The pictures will not be viewable..

Then, say I go to the form in question and do some sort of edit, maybe add a command button (any button, doesn't matter), then review the form, and Ta da! the pictures are viewable again

Then...

I close the database
I reopen the database again later (doesn't matter if it's 5 minutes or an hour)
The pictures are no longer viewable

But again, doing something like editing the form - to add a button, delete a button, whatever. And the pictures come back

The editing has nothing, absolutely nothing, to do with the pictures directly. Just an edit to the form in question where the image is

Something really strange is going on with this version of Access I believe. I could be wrong, of course, but I believe there is a bug somewhere

 

[Bailey Assocites]

When you open access it will not load pictures in order to save processing power. All you have to do is clic on the link na then it will load.

 

[Roger]

Bailey

There is no link to click. The code given to me is supposed to load the pictures automatically when the form is opened

This morning no matter what I do the pictures don't open.