Displaying SQL Server Image in Access Form or Report

  • Thread starter Thread starter Gwen Powell
  • Start date Start date
G

Gwen Powell

Our student system based in SQL Server 2000 contains pictures of our
Students. Our Student System Application (FoxPro) displays the pictures but
does not have the ability to print ID cards with the Student pictures. I
want to use Access 2000 (the verison that the schools are on) to create
Student ID cards. The only issue I have and need help on is: How can I
make Access 2000 display the pictures? When I look at the table the cell
contains "OLE object" but when I query the table it contains "Long binary
data". When I view the data from the Interprise Manager it simple displays
as "binary". I have searched both Microsoft and Google and have not found
the answer.
Thanks in advance for any help pointing me in the right direction.
Gwen Powell
Torrance Unified School District
 
hi,
if you are talkng id badges, then you are talking reports.
see this web site on how to display images in an access
report.
http://www.microsoft-
accesssolutions.co.uk/bound_image_report.htm
(it wrapped. suppost to be one line)
i hope you didn't try to import the images into access.
it works much better if you just put the file path to the
images in the tables. images in access causes file blote.
not sure but i was told that for each 10k of image causes
a 1 meg blote in access.
see this site for info from a mvp(Lebans) that claims to
have solved this issue. I have not tryed this yet. access
was designed as a multiuser system with a front end/back
end set up with all the front ends linked to the single
back end so that users all use the same data. so i am of
the school of thought - never put anything in your db that
you can link to even if it's not a front end/back end
setup. this is how access was designed to opperate.
good luck.
 
Thanks but I am very well versed in linked images and native Access images.
In this case these are binary images stored in the SQL Server 2000. It
really doesn't matter whether it is a report or form, it will work the same
way as soon as I find out how to get Access to read it. From what I get
from the Microsoft site and other sources I have been looking at, Access has
header and footer information i the binary file where SQL Server does not.
I am looking for a way to get Access to read the binary file so that it can
display the image. It might be that I will have to get an interpreter to
read the file to a mapped temporary file so that Access can read it or
import the file into a temporary Access binary field. The problem is that a
SQL Server 2000 image is not readable by Access with the ODBC connection and
dropping it into a form or report.

So, I am still searching for the best method (or any method at this point)
to display the picture.
Gwen
 
Thanks Stephen,
Almost there but it doesn't read the SQL Server file. But I think I can now
utilize some other things I found to convert from the SQL Server to Access.
Gwen
 
Gwen can you post back with your code when you are finished? This issue
comes up a lot and it would benice to have some sample code to refer
users to.
If you need any help with the reading/writing to disk please let me
knwo.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top