Jim Lawrence
accessd at shaw.ca
Sun Jun 19 10:14:48 CDT 2011
There are a number of programming environments that have a full suite of apps that will allow you to modify and re-size any image. PHP is one language that comes to mind and there are a number of other Open Source and purchased applications that will do what you need. Here is one code sample: http://www.white-hat-web-design.co.uk/articles/php-image-resizing.php http://php.net/manual/en/function.imagecopyresampled.php Access is brain-dead when it comes to images...no built in editing features The image is either right or it bails...and when someone tries to load a 2GB RAW file there is nothing the system can do. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jurgen Welz Sent: Friday, June 17, 2011 1:32 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] OT - FW: New computer I've got a poser. I've built a photo indexing application. It displays the jpg file in an image control and allows the user to assign certain attributes that make the picture retrievable using a search form. I've noticed that Access 2003 balks at jpgs above a certain size. I have a jpg at a bit over 9 megabytes that Access tells you is too large to load. I've recently had a few users complain that the images don't load in the indexing form. It turns out that most of these images are near 5 megabytes. What's interesting is, on my screen, when I click the next and previous buttons, every 2nd image loads starting from the first. IE, image001.jpg, image003.jpg, image003.jpg, image005.jpg. If I copy image001 and name the copy image000.jpg, still every 2nd image loads, but this time, it's all the alternate images that didn't load the first time. IE, image000.jpg, image002.jpg, image004.jpg, image006.jpg. Nothing about the file changes. On other folders where the pictures are smaller, all the images load correctly. I logged into another terminal running a higher resolution, and none of the images loaded. The terminal I'm stuck on is the lowest resolution we have. Is anyone aware of some kind of image control limitation, and why the bizarre 'every 2nd image' behavior? Ideally, I'd like all the pictures to load correctly and I'd hate to have to tell everyone to dial their new digital cameras down to 2 megapixels. Ciao Jürgen Welz Edmonton, Alberta jwelz at hotmail.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com