[AccessD] Update Query - Need to Speed It Up

Henry Simpson hsimpson88 at hotmail.com
Tue Jun 3 10:34:42 CDT 2003


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030603/5eddad08/attachment-0001.html>


More information about the AccessD mailing list