Displaying SQL Server Image in Access Form or Report

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

anonymous_at_discussions.microsoft.com
Date: 02/28/05 

Date: Mon, 28 Feb 2005 12:31:37 -0800

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.

>-----Original Message-----
>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
>
>
>
>
>.
>

Relevant Pages

  • Re: Images are disapearing
    ... pictures that doesn't change any thing. ... If I go Tools, Graphics Mgr, The name of the picture is there and the ... images, in my case on my PC, Home page_filesthe images are not ... > does not display images. ...
    (microsoft.public.publisher.webdesign)
  • Re: reading images from a folder for image cropping
    ... "Nilushi Dissanayake" wrote in message ... I am a student and i am new for the matlab software, and i want to use a code to read all my images in a folder and crop them for the preprocessing. ...
    (comp.soft-sys.matlab)
  • Is this possible? Help Requested
    ... match them to the images I shoot of them. ... and in a final column I name ORDERS I input what package each student ... Excel add up the total value of all sales from the info I have? ...
    (microsoft.public.excel)
  • displaying image in report
    ... hi, I have a table named "student", and I have saved all the student ... picture images to my hardisk on a specific location. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: duplicate Linux installation
    ... > groups are being taught the linux principles. ... To prevent one student from ... Use something like systemimager to keep the images on a server and install ...
    (comp.os.linux.setup)