[AccessD] Update Query - Need to Speed It Up

You can drive nails with a rock too, but it still makes more sense to
use a hammer. <g>

Charlotte Foust

-----Original Message-----
From: Henry Simpson [mailto:hsimpson88 at hotmail.com] 
Sent: Tuesday, June 03, 2003 7:35 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Update Query - Need to Speed It Up


Access is not used exclusively in multi user environments and for those 
without fancy image processing or signal processing software, it can be
used 
to store and process 30 bit image scans and wav files quite nicely as
well 
as log all kinds of high frequency sampled data.  For example, if you
want 
to drop a green cast out of the shadows and don't have photoshop, it's a

terrific tool, but you can do it in Access too.  If you want to reduce
or 
increase the dynamic range of an audio file that was poorly recorded,
all 
you need to do is apply a scaling factor to some numbers with an update 
query.  My Canon D60 with a 5 megapixel ccd shoots typically 20 megabyte
raw 
images and the Olympus P400 dye sub printer prints 7.7 megapixels on A4 
paper.  Although Access is not as convenient as photoshop, a tool like 
Access is just another means to manipulate data that encompasses more
than 
merely Names, addresses and phone numbers.

No doubt Rocky wouldn't be messing with 2.5 million records without
reason 
and there is no reason to assume that this would necessarily be a multi
user 
environment.  Such an assumption in the face of the information given
was 
improbable.

Hen

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=features/junkmail