Hi Roy,
storing pictures in database as OLE objects - is not a good idea, your
database will grow dramatically.
Best option is to store pictures as file on local or network drive and show
then in access using picture control or some 3rd party activex control,  for
example http://www.ammara.com/

Roy,

If you look at the Northwind sample database that came with your access
(click Help, sample database) you can see how it is done in their
employee table/form.  The picture still resides in a folder (network or
hard drive) and is loaded.

Its a little tricky to reverse engineer it but it works for me.

Good Luck,
Mark

In this case the OLE server is simply an Image/paint program that:
1) Can function as an OLE Image server
2) Is registered to handle the specific Image file types you want to
insert into the OLE obect field.

In most cases, MS Photo Editor is used as the OLE Server program. It
must though, be setup as the default/registered handler for the image
file types in question. MS Photo Editor is no longer included with
Office 2003. YOu will have to find you Office XP or WIn2K disks and
install MS Photo Editor only!

The simplest method to associate a program with a specific file
extension(BMP,JPG,etc.) is to:
1) Open a folder containing the Images you want to insert.
2) Right click on a file while holding down the SHift key.
3) From the popup menu select "Open With".
4) Scroll down the Open With Dialog window until you find MS Photo
Editor and select it.
5) Check the Always use this program to open this file type CheckBox
control.
6) Click OK.

Repeat the steps once for each different type of Image file you want to
embedd in your table.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.