Best way to put .jpg's into a database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the simplest way to put jpg's into an Access table? I just want to
print them in reports. It used to work fine until, as usual a MS "upgrade"
damaged me (from office 2000 to XP/2003) when it apparently lost that ability
due to removal of some other image handling applet that was in 2000.
 
The best way is don't.
images take up a lot of space and Access mdbs are limited to 2GB. It
doesn't take long to fill up a database with images. It is better to create
a directory to store your images and link to them.
 
Thanks, that's fine. But "how do you do that?" (if ANYONE could answer) is
what I meant to ask in my poorly worded question. Trying to just use the
help files is how I got into my original method that got broke by the
"upgrade." I'm smart as a power user (not developer) in Access, but really
dumb in this particular area. A few tips from someone who know this would
save me 20 hours of trial and error and mistakes. Not looking for detailed
instructions, just quick notes to get me pointed in the right direction.
Thanks again.

Type of field to use (OLE, hyperlink, text)?
Quick note on the method to insert the link?
Quick note on the method to insert in into a report?
 
Perhaps I didn't fully explain my answer.
Create a table to keep track of the images you want to use. Use a hyperlink
field in the table to point to the images stored externally.
 
FredFred said:
What is the simplest way to put jpg's into an Access table? I just want to
print them in reports. It used to work fine until, as usual a MS "upgrade"
damaged me (from office 2000 to XP/2003) when it apparently lost that ability
due to removal of some other image handling applet that was in 2000.
Click to expand...

You don't want to embed graphics into a table as this causes
significantly bloating of the database. Frequently about one Mb per
graphic.

For more info see the Image Handling Tips page at my website.
http:\\www.granite.ab.ca\access\imagehandling.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top