Insert Photo's without inflation

[Guest]

I've constructed a database that allows me to attach photo's to records.
I've noticed that this attaching has inflating the database. I am interested
in the best way to create a database that will allow me to insert pictures
into records. I've also been told that there is a way to insert a batch of
pictures to a series of records so that I don't have to do them one at a time.

Please advise--------can you email me at (e-mail address removed)
THANKS!

 

[Guest]

The usual answer to this question is - dont store the picture in the databse,
but store only a link to the pictures.

As you have discovered, storing the pictures bloats the database
considerably. It is much more efficient in storage terms to keep all the
picutres in a seperate folder or server, and write a small piece of code that
brings up a file selecrot box, and inserts the path name to the picture in to
the specified field.

HTH

Neil
www.nwarwick.co.uk