HOW DO I SAVE PICTURES IN ACCESS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI,

I AM MAKING A SMALL DATABASE USING MS ACCESS. I HAVE ALSO CREATED A FORM IN
ACCESS ITSELF WHERE THE USER WILL BE ENTERING THE DETAILS REQUIRED. NOW I
ALSO WANT THE USER TO BE ABLE TO ADD A PHOTO WITH EVERY RECORD. HOW DO I GO
ABOUT ADDING A PHOTO.
 
First of all, do NOT save your pictures in the database. Rather, simply
store the path to the picture and display it when needed. Take a look at the
northwind database, that ships with access, and see how the Employee form
does it.
 
Store a path to the photo rather than trying to store the BLOB. Storing
pictures is not very efficient in Jet, and you'll be fighting bloat
continually if you try save the pictures, rather than just a string that
points you to the pic.
 
Back
Top