Inserting a photo in a form

  • Thread starter Thread starter JT
  • Start date Start date
J

JT

Please help,
I am trying to insert photos of my employees into an employee database but
find that the database grew by 15 MB with just 3 photos.
I am having trouble inserting and would like to know how to insert photos
simply and how to keep the size down.
I thank all that can assist me in advance.
JT
 
Don't!

Look at storing the path and filename of the picture rather than attempting
to store it in the database.

The problem with Jet is that it stores all picture data in bitmap format so
even a small JPEG file can cause enormous growth in filesize.
 
Have a look at the employees form in NORTHWIND.MDB. The photo location is
stored as a string variable in the photo field.
 
Back
Top