[AccessD] Access FE for storing and viewing photos

Borge Hansen pcs at azizaz.com
Mon Aug 28 01:28:58 CDT 2006


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




More information about the AccessD mailing list