Problem viewing linked images on form

[John Reichard]

I have created a database using Access 97. In a table, I have created a
field set to OLE Object. I then created a form with that field in it. When
I open the form, I right-click to insert an object (create from file). When
I choose an image (.jpg or .gif), only the file name shows up in the field.
I can double-click on the name and the image will open in a graphics program,
but I want the image to show up on the form. This happens both when I try to
embed the file or just link the file. If I try to insert a .bmp file, I get
the following error "A problem occurred while accessing the OLE object. The
OLE Server may not be available because it's on a network server and you lost
the connection. Try re-establishing the connection. The OLE object may be
stored in a linked file, but the file isn't available. Activate the OLE
server outside of [my program name], and then open the file containing the
OLE object to verify that it still exists and can be accessed." The first
explaination is not the problem because I'm not working from a network. As
for the second explaination, I have no idea what an OLE server is or how to
use it. The .bmp file does exist and can be opened in a graphics program.

All I want to do is be able to insert a picture (linked or embedded I don't
care) based on a file. I'm not talking about just inserting a picture on my
form. This form opens up for different records and I would like the ability
to have a different image for each record. An example would be an employee
list where a form would open for each employee where an image could be loaded
showing that employee.

Is there anyone out there with any suggestions? Thank you.

 

[John Reichard]

Hello Everyone:

Right after I posted this message I did a search within the discussion group
for OLE (I know...I should have done this first) and found the solution to my
problem. What I (or anyone else having this problem) need to do is first
open my graphics program and open the image. Then from the Access database I
insert the object. The image now shows up in the form just as I want it. I
think it has something to do with a filter or converter that doesn't work
well within Access, but if it is already open in a graphics program, it is
easier to import into Access. Again....sorry everyone for posting a problem
that was solved moments later. But maybe this will be helpful to someone
else out there. Thanks.

 

[Stew Hayles]

I tried your fix Richard and it worked so thanks for that. I wondered how
ever do you have to open every image your doing first before linking or after
you have done your first one will it work from then on automatically?

Hello Everyone:

Right after I posted this message I did a search within the discussion group
for OLE (I know...I should have done this first) and found the solution to my
problem. What I (or anyone else having this problem) need to do is first
open my graphics program and open the image. Then from the Access database I
insert the object. The image now shows up in the form just as I want it. I
think it has something to do with a filter or converter that doesn't work
well within Access, but if it is already open in a graphics program, it is
easier to import into Access. Again....sorry everyone for posting a problem
that was solved moments later. But maybe this will be helpful to someone
else out there. Thanks.

I have created a database using Access 97. In a table, I have created a
field set to OLE Object. I then created a form with that field in it. When
I open the form, I right-click to insert an object (create from file). When
I choose an image (.jpg or .gif), only the file name shows up in the field.
I can double-click on the name and the image will open in a graphics program,
but I want the image to show up on the form. This happens both when I try to
embed the file or just link the file. If I try to insert a .bmp file, I get
the following error "A problem occurred while accessing the OLE object. The
OLE Server may not be available because it's on a network server and you lost
the connection. Try re-establishing the connection. The OLE object may be
stored in a linked file, but the file isn't available. Activate the OLE
server outside of [my program name], and then open the file containing the
OLE object to verify that it still exists and can be accessed." The first
explaination is not the problem because I'm not working from a network. As
for the second explaination, I have no idea what an OLE server is or how to
use it. The .bmp file does exist and can be opened in a graphics program.

All I want to do is be able to insert a picture (linked or embedded I don't
care) based on a file. I'm not talking about just inserting a picture on my
form. This form opens up for different records and I would like the ability
to have a different image for each record. An example would be an employee
list where a form would open for each employee where an image could be loaded
showing that employee.

Is there anyone out there with any suggestions? Thank you.