I have a simple database using Access 2000 which currently has three fields. I
keep track of my lighthouse collection. The fields are all text, and list the
name of the light, which company it's from, and what state it's located in. I
was wondering if it's possible using Access to add another field and insert a
picture of each light as part of the database? Thanks for any insight.

Best way is to store your pictures in an external folder say ....My
Documents\Lighthouse Pictures\Eddyston Light. Then in your table you store
the path say LighthousPath (Text 255 characters) and on your form you have
an image control called LightHousePic. On the form OnCurrent event you heve
a simple line of code

Me.LightHousePic.Picture = Nz(LighthousPath)

Do not use OLE objects (the alternative way) as the bloat your database
HTH

Phil


<rfdjr1 (AT) optonline (DOT) net> wrote