bad picture zoom

[blarson0]

Hi! I have a database with quite a few pictures, I am wanting to move them out of the database to save space. I put them in a file on the hard drive. I was using bound OLE objects to display them, but now am using picture objects. When the picture object is in zoom mode, to show the whole picture, the picture becomes grainy and discolored. It looks good in an OLE object.

Can I fix this so that the picture object will look good? Or does anyone have any code for using unbound OLE objects?

Thanks!

-Brad

 

[gwinn7]

Personally, I would keep the pictures in the database. There is a control you can get that will process those JPGs with no overhead. Its called, DBPix.

If you want to put your pictures to the filesystem, use the, free with Windows, Kodak control. Check your control list or 'References' in MS Access for it. The original OLE control has a lot of overhead and is slow. I recently did a speed test of these controls.

Control Overhead Load Time
========================================
DBPix None 45ms
Kodak Filesystem 200ms
UnboundOLE Filesystem 800-1600ms
BoundOLE Lots! 250ms
=========================================

Hope that helps your project. If you elect to use the Kodak control, you may encounter problems with picture quality, but this can be corrected by a property setting of the control. Let me know if you get that far and I will help if I see your post.

Gary
gwinn7
A+, Network+

 

[gwinn7]

btw, the "load time" is in reference to the time it takes to load the picture. Anything above a quarter of a second is really noticable.

Gary
gwinn7
A+, Network+