Load Images into SQL2005 backend

  • Thread starter Thread starter Harry Athey
  • Start date Start date
H

Harry Athey

I have a need to load pictures from a file into the SQL2005 backend database
through access 2007 front end. The picture file will be destroyed within
minutes by an automated process but I need to store the actual pictures in
the database and not a pointer to the file.

I then need to know how to pull the picture back from the database and
display it in a form.

I know this will take up a lot of room on the database, but that is the
requirement.
I cannot copy the file to another location or filename and then add a link
to the file into the database for security reasons.

I seem to be able to find some examples in c# out on the net, but I need a
VBA solution for access 2007.

Thanks for the help.
 
Alex thank you for that information.

OK, so now I can read the info into the database and I can even write a file
to the disk with your help, but how do I get the information into an image
control? I understand how to read the data from the database, but if I don't
want to write it to a file, how do I get the image to see the data?
 
Back
Top