Accesss 2003 - photos used in a database

The best way is to leave the pictures on the hard drive an only store the
path to them in a table. Then you can load the picture at run-time into a
form or report. On my website (www.rogersaccesslibrary.com), is a small
Access database sample called "Pictures.mdb" which illustrates how to do
this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"FrankSpokane" wrote in message
...
I am designing an mdb for a real estate firm and they want to be able to
put
pictures of their property in the individual database record along with
the
listing information.

How do I best do this, and how do I get the pictures from their camera
into
access?

Then, can Access be the source file to then create other realated
documents
in Publisher and Powerpoint and Excel and Word ?

High Hopes

Thanks Roger. I'll do that right away.

Is there no way to have the actual pictures display in real time in the
Access record?

I created an OLE Object field, and was able to insert a picture in that, but
when you view the access record this field shows up as a white box with just
the filename of the graphic displaying (property1.jpg) and you have to double
click on this field - and then windows picture manager than displays the
actual picture.

What are the pros/cons of doing it this way compared to your way?

Thanks


"Roger Carlson" wrote:

The best way is to leave the pictures on the hard drive an only store the
path to them in a table. Then you can load the picture at run-time into a
form or report. On my website (www.rogersaccesslibrary.com), is a small
Access database sample called "Pictures.mdb" which illustrates how to do
this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"FrankSpokane" wrote in message
...
I am designing an mdb for a real estate firm and they want to be able to
put
pictures of their property in the individual database record along with
the
listing information.

How do I best do this, and how do I get the pictures from their camera
into
access?

Then, can Access be the source file to then create other realated
documents
in Publisher and Powerpoint and Excel and Word ?

High Hopes

The only real positive thing I can think of for storing the OLE object in
the database itself is that they are all stored in the same physical file
(mdb). On the minus side: 1) OLE objects, like Memo fields, are less stable
and are suseptible to corruption, 2) they cause your database to grow very
large very quickly, and 3) as a result, cause your database to become very
slow.

I can't think of a single post on any newsgroup or forum I've been on that
recommended storing pictures in the database itself.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L



"FrankSpokane" wrote in message
...
Thanks Roger. I'll do that right away.

Is there no way to have the actual pictures display in real time in the
Access record?

I created an OLE Object field, and was able to insert a picture in that,
but
when you view the access record this field shows up as a white box with
just
the filename of the graphic displaying (property1.jpg) and you have to
double
click on this field - and then windows picture manager than displays the
actual picture.

What are the pros/cons of doing it this way compared to your way?

Thanks


"Roger Carlson" wrote:

The best way is to leave the pictures on the hard drive an only store
the
path to them in a table. Then you can load the picture at run-time into
a
form or report. On my website (www.rogersaccesslibrary.com), is a small
Access database sample called "Pictures.mdb" which illustrates how to do
this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"FrankSpokane" wrote in message
...
I am designing an mdb for a real estate firm and they want to be able
to
put
pictures of their property in the individual database record along
with
the
listing information.

How do I best do this, and how do I get the pictures from their camera
into
access?

Then, can Access be the source file to then create other realated
documents
in Publisher and Powerpoint and Excel and Word ?

High Hopes