View Single Post
  #11  
Old December 12th, 2008, 02:00 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default OLE Object Makes Database to Large

BTW, below is some of the text I saved from posts on this.....I just "got
by" on this, did not write these nor do I know them well enough to answer
questions without digging back into what we did.

- - - -

Store the pictures in a separate folder from the database. Add a
field named PicturePath to your table and record the full path to the
picture for each record. Add an image control to your form. Be sure you have
PicturePath in the recordsource of your form. Put the following code in the
Current Event of the form: Me!NameOfYourImageControl.Picture = Me!PicturePath.

- - - -

Add an image control from the toolbox for displaying your pictures. Select
the image control, open properties, find the picture property and bind it to
the path to your picture in your table as Fred describes.