Multiple images on an Access form in Access 2007

[Suneel]

I'm building a db of pictures with captions, and am creating a form to
display 30+ images together with picture numbers that allows them to be moved
around within their order, copied, etc, similar to the slide browser in
powerpoint.
The form works ok, but takes about 2-3 mins to load. I've used image
controls and linked references rather than embedded references, but it still
takes time to load.
The pictures are currently 2-3 Mb in size, but even with smaller pictures I
have a similar problem.
Thanks very much.
Any suggestions?

 

[Sylvain Lafontaine]

Yes: use anything but Access if you want to manipulate images. Access 2007
is much better than any previous in this regard (your current 2-3 mins to
load would be nothing in comparaison of the time Access 2003 would probably
take to do the same thing) but you can see that it's still a turtle in this
regard.

Maybe using the DBPix control from Ammara will give you a better
performance; however, it's not free and if you really want to do any
advanced image manipulation, you should really go for a more powerful
solution such as .NET.

 

[Suneel]

Thanks very much. Very helpful to know I wasn't doing something obviously
wrong.
As I don't have experience of .net yet I'm still open for other ideas.
Thanks again Sylvain.
Suneel

 

[Sylvain Lafontaine]

Yes, the standard GUI (Graphical User Interface) for Access is simply not
adapted to the internal manipulation/displaying of images. They have
corrected some of this defiency in Access 2007 but it's still a big hurdle -
even on a powerful machine - to do any image displaying/manipulation on a
form excerpt for the simplest thing (ie., displaying only a single image at
a time).

If you don't know anything about .NET, you could give a shot at DBPix but
beside its price, I never tried it personally so I cannot give you no
garanty of performance at all.

For your last question, I'm sorry but I don't have any other ideas.