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.
add a picture to my family tree of relatives.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Philip Herlihy
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
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
D
Daniel Pineault
If you google you would find numerous tutorials and even sample databases
which illustrate the best methods to do so. Below is are two such samples
that you can inspire yourself with.
http://www.devhut.net/index.php?lang=en&pid=0000000007#images
http://www.devhut.net/index.php?lang=en&pid=0000000007#album
--
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.
which illustrate the best methods to do so. Below is are two such samples
that you can inspire yourself with.
http://www.devhut.net/index.php?lang=en&pid=0000000007#images
http://www.devhut.net/index.php?lang=en&pid=0000000007#album
--
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.
D
Daniel Pineault
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.
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.
A
Alnewt
Is there a certain type of field in the table I will need to store the
path/filename?
path/filename?
J
John Spencer
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
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
T
Tony Toews [MVP]
Daniel Pineault said:If you google you would find
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/
T
Tony Toews [MVP]
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.
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/
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.