Problems linking an OLE object to a form

I have created an OLE field in my table. I also have a form that I want to
display a picture bound to the same table as the rest of the data resides. I
have dragged the field name to my form in Design View. At that point I have
attempted to create the link by right-clicking in the appropriate field on
the form and selecting Insert OLE object and selecting "create from file" and
selecting the correct path. I then checked the link box. When I click on
OK, my database freezes. The image I am using is only 90Kb, so I figure it
shouldn't take more than a few seconds to create the link. I basically have
to shut down the database and reopen it. Any assistance you can provide
would be greatly appreciated.

radar_indy

bummer on the freeze action....

there is one point that is confusing....you have the OLE field in the Table.

but then you state that you are creating the link at the Form design level....

Since the OLE field is in the table - when the table is in DataView - you
should be right clicking in the field of each record and selecting the
path.... so that the path is in the record of this Table.

You would not then set any path in Form Design -you would only drag the
Control onto the field....

--
NTC


"Ron" wrote:

I have created an OLE field in my table. I also have a form that I want to
display a picture bound to the same table as the rest of the data resides. I
have dragged the field name to my form in Design View. At that point I have
attempted to create the link by right-clicking in the appropriate field on
the form and selecting Insert OLE object and selecting "create from file" and
selecting the correct path. I then checked the link box. When I click on
OK, my database freezes. The image I am using is only 90Kb, so I figure it
shouldn't take more than a few seconds to create the link. I basically have
to shut down the database and reopen it. Any assistance you can provide
would be greatly appreciated.

radar_indy