[AccessD] Access FE for storing and viewing photos

Have a look at Candace Tripp's example getting
jpegs from a directory

Picture in Database 97 and 2000

http://www.candace-tripp.com/access_downloads.htm

or Pictures mdb's here
http://www.rogersaccesslibrary.com/TableOfContents3.asp

Jim Lawrence wrote:

>Hi Borge:
>
>The best method I have found is to simply store the pictures as separate
>items in their own folder and do not try to inset them into the database.
>They will load faster, you can use a number of formats, like jpg and the
>database can then handle thousands picture, if they are not imbedded. Just
>use a straight IMAGE object and fill its picture property with the name of
>the picture like "\\Myserver\MyPictures\UncleFred.jpg" 
>
>HTH
>Jim
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Borge Hansen
>Sent: Sunday, August 27, 2006 11:29 PM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] Access FE for storing and viewing photos
>
>Hi,
>
>What's the best approach for creating a database for storing and viewing
>photos?
>
>If Access FE and BEmdb
>- use approach as per the Northwind Db?
>or
>- bound object frame?
>
>I've experimented with the bound object frame and "out of the box" can only
>manage to store .bmp files in the bound field .
>I can store .jpg files - but cannot immediately view them on the form as I
>scroll from record to record - I have to double click the
>ole object and then I can view the .jpg
>
>What gives best functionality using Access FE,
>
>storing pictures in a Table  (and is .bmp only choice here; what about .jpg
>format)
>or
>storing pictures as separate files in a separate folder and accessing them
>using the Northwind approach
>
>
>What about SQL2005 Express as a backend?
>
>Regards
>borge
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada