Linking Jpegs in Access 2003 Forms

[Q Sligh]

First of all let me say, I'm NOT a programmer. I went a bought several books
on Access 2003 inorder to create simple databases forms. I've created a form
for our little company which I wish to display the employee's picture on the
form. When I follow the procedures in my book, all that is displayed in the
name of the jpeg and not the actual picture. If I click on the name the
picture is displayed in another window. I have went on the web and read so
much that I'm crossed eyed. I've reinstalled MS Picture Manager like one
article said and still no joy. Is there a SIMPLE way to do this like the
book stated? PLEASE HELP ME!!!

 

[Arvin Meyer [MVP]]

First of all let me say, I'm NOT a programmer. I went a bought several
books
on Access 2003 inorder to create simple databases forms. I've created a
form
for our little company which I wish to display the employee's picture on
the
form. When I follow the procedures in my book, all that is displayed in
the
name of the jpeg and not the actual picture. If I click on the name the
picture is displayed in another window. I have went on the web and read
so
much that I'm crossed eyed. I've reinstalled MS Picture Manager like one
article said and still no joy. Is there a SIMPLE way to do this like the
book stated? PLEASE HELP ME!!!

In order to display a bound OLE object you need a registered OLE server that
is associated with the filetype. I should also mention that storing images
in a database causes bloat at least to the file-size of the image, but can
be much larger. I suggest, storing a path to that image on your hard drive
in your table, and using an Image control in you form to display it. A
sample database that does just that and also allows you to collect and store
the paths is available at:

http://www.datastrat.com/Download/Picture2K.zip