[AccessD] Access FE for storing and viewing photos

Borge:

I have a hone-grown picture viewr which I made before Window's ever so 
handy built in picture viewer which load pictures in sequence from a 
folder using an unbound image frame.  The folder is selected from the  
folder browser.  I can send it to you off line if you want.  It's only 
49k zipped.

The only problem I had with it was when you load the picture 
(imgPicture.Picture = astrPicArray(intCurrentPicture)
) you get a progress bar which flashes up for a fraction of a second.  I 
experiemnted with turning it off by using a function that sets a 
specific registry key ("Software\Microsoft\Shared Tools\Graphics 
Filters\Import\JPEG\Options") but it only worked on one machine - seems 
to be very OS dependent.

Let me know if you want it.

Regards,

Rocky
 

Borge Hansen wrote:
> 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
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com