adding pictures in Access 2007

I have a database that I created and one field is Picture with the Data type
being OLE Object. I have created a form from this table and when I link a
picture in the record it shows up as "filename".jpg (command line). I have
to double click on the file to open the picture. This is not what I want. I
would like for the picture to be present @ the time I look @ the record. I
have read through this site and can't find anything that is associated with
Access 2007. I know it can be done because I have another database that I
created in Access 2002 and it worked fine.

Is this a problem associated with 2007 or am I doing something wrong. Any
help would be great.

I've heard Access 2007 may have improved the situraion, but up through at
least 2003 the OLE object was not a viable store pictures; the way to do it
is to store them separately and then just store their location and file name
in the table, e.g. in a text field. Then there have been several posts on
how to display pictures in a form or report. (I don't know it fluently
enough to just write it out here from memory.)

Sincerely,

Fred





"dplove" wrote:

I have a database that I created and one field is Picture with the Data type
being OLE Object. I have created a form from this table and when I link a
picture in the record it shows up as "filename".jpg (command line). I have
to double click on the file to open the picture. This is not what I want. I
would like for the picture to be present @ the time I look @ the record. I
have read through this site and can't find anything that is associated with
Access 2007. I know it can be done because I have another database that I
created in Access 2002 and it worked fine.

Is this a problem associated with 2007 or am I doing something wrong. Any
help would be great.