Photos in a Membership Database

[RyanPitt]

Hi all,

Have designed a membership database for my club, which i am trying to insert
photos in for each persons records.

I have set up a table for the "photo" and set the type as an OLE Object, i
have also set up a form for this table, but when i right click on the OLE
object and select Insert Object...|and insert my photo as a link, i get the
photo ok, but this photo is the same photo throughout the database, and not
just for that record.

Any ideas on why this is happening?

Cheers

 

[Arvin Meyer [MVP]]

You have used an unbound OLE object. Either use a bound OLE Object or an
image control. There are several methods of handling this, but usually it is
better to store the images separately to avoid database bloat (which can be
very large). One way is to put the files in a separate directory and connect
to them on the fly. This is demonstrated at:

http://www.datastrat.com/Download/Picture2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access