Pictures in Access

  • Thread starter Thread starter Alnewt
  • Start date Start date
A

Alnewt

How do I add pictures to a database. I'm using Access 2003. I would like to
add a picture to my family tree of relatives.
 
Access 2003 doesn't have the "attachment" data type that was introduced in
Access 2007, but I understand (watch for corrections!) that you can use an
OLE Object type to store pictures. However, either way I'd leave the
pictures where they are and use a Hyperlink data type, so the database
merely stores their location. Might also be worth looking up "Hyperlink
Base" in Help - this gives you the option of using relative links, and
changing the base is an easy way of using a new location (eg. a network
drive) for the files.

Phil, London
 
When using Access 2003 or prior, NEVER "use an OLE Object type to store
pictures" in a database as it will leave to database bloating and corruption!

Instead, always simply store the path/filename in your table and use it as
required in your database.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Unless you have very long path/filename combination you can use a text field
set to 255 length.

If you do have very long names then you might need to use a memo field or
store the path/filename using the short name. I know there is VBA code out
there that will allow you to determine the short name.

The functions fGetShortName (8.3 naming scheme)and fGetLongName will return
the appropriate filename for you. See
http://www.mvps.org/access/api/api0020.htm

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Daniel Pineault said:
If you google you would find
Click to expand...

Actually searching for technical questions has become increasingly
more and more useless these days as Google and other search engines
index all the online forum sites. The problem though is that most of
the online forum sites mirror the NNTP newsgroups, such as these, and
thus you find many, many duplicate answers. Or answers telling you to
search. <smile> So the more specific URLs you can provide the
better. Which you did.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Alnewt said:
How do I add pictures to a database. I'm using Access 2003. I would like to
add a picture to my family tree of relatives.
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
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Back
Top