Accesss 2003 - photos used in a database

[FrankSpokane]

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

 

[Roger Carlson]

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/wa.exe?SUBED1=ACCESS-L

 

[FrankSpokane]

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]

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/wa.exe?SUBED1=ACCESS-L