[AccessD] Access FE for storing and viewing photos

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com