[AccessD] OT - FW: New computer

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





More information about the AccessD mailing list