Pictures in Database ?

[Ty]

Does anyone have suggestions on pictures in the database?

I have a friend who wants to have 2 pictures in her
database for each record. This has been done as OLE and
she right clicks on the field and insert object, ....

The picture does into field 1 then the next pictures goes
into field 2. This works, but I have noticied the
database is getting large fast and I don't know if this
will cause issues in the future.

The reports that she runs needs to print out the pictures.

Any ideas, suggestions, opinions, etc. are very welcome.

Thanks.

Ty

 

[Gina Whipp]

Storing pictures in a database does cause growth at an alarming rate because
of the way Access stores OLE object. Take a look at
http://www.mvps.org/access/forms/frm0030.htm for a better way to handle
pictures in Access.

 

[Jack]

Use the Image Control instead of an Object Frame control.
If your pictures are all the same dimensions, use a sample
picture to size the frame around it. If your pictures are
of different dimensions, make your frame square and set
the Picture Alignment property to "top left". In this
case, there will be a certain amount of dead space at the
bottom or right depending upon the dimensions of each
picture. Then set the following properties of the Image
control:
Picture - "(none)"
SizeMode - Zoom
Picture Type - Embedded
Picture Alignment - [see above]
Picture Tiling - No

Depending upon the coding, the table will have a text
field (not an OLE field) that holds the file name or
complete path to each picture. Check the Northwind sample
database for version 2002, where they have switched to the
Image control in their Employees form.

 

[Arvin Meyer]

Using an Image control and loading the image at runtime will keep the
database from bloating. There is an example on my website:

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