Displaying SQL Server Image in Access Form or Report

G

Guest

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.
 
S

Stephen Lebans

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.
 
Top