Inserting a photo in a form

[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

 

[Craig Alexander Morrison]

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.

 

[Allan Murphy]

Have a look at the employees form in NORTHWIND.MDB. The photo location is
stored as a string variable in the photo field.

 

[Arvin Meyer [MVP]]

Have a look at my sample database for 1 method of doing it. All the code and
forms are importable into your database:

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