Load Images into SQL2005 backend

[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 Dybenko]

Hi,
have a look here:
http://support.microsoft.com/kb/210486/en-us
and here:
http://support.microsoft.com/kb/255632/en-us

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Alex Dybenko]

Hi,
if you are using Access image control - then only way is to save picture to
temp location, show it in image control and then delete it

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Harry Athey]

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?