Photos in Access

[John]

I am looking to create a photo intense database but
access whats to change the photos to BMP I want to store
them as JPG files in the database

 

[Gary Miller]

The general rule is to never store photos 'in' the database.
Store the path to where the photos live and use your forms
or reports just to display them as needed. Lots of
documented problems, especially with db size, when you
actually put them in the db.

Gary Miller

 

[Larry Linson]

I am looking to create a photo
intense database but access whats
to change the photos to BMP I
want to store them as JPG files
in the database

I don't understand what you mean by "access whats to change the photos to
BMP". In any case, I disagree with Gary -- there is no "general rule", but
there are specific considerations in what approach to choose. The
considerations for three approaches to handling images in Access databases
are in the article included with the sample databases illustrating those
three approaches that you can download from http://accdevel.tripod.com. You
may even be able to use some of the sample application as a "starter" for
your own. There are other suggestions, BTW, at the FAQ site,
http://www.mvps.org/access and at MVP Stephen Lebans' site,
http://www.lebans.com.

Larry Linson
Microsoft Access MVP