[AccessD] Zipcodes within a radius

Well, having worked at one time for a firm that did commercial mailings
and validated their addresses using that kind of database, I know the
program we used had prefilters, i.e., a street address or company name,
a city or state, etc.  You entered one of those and it started chugging
through the data that matched.

Charlotte Foust   

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
Sent: Friday, March 23, 2007 10:28 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Zipcodes within a radius

<war story>

I'm working with one on a client site (a publishing who also does bulk
mailings). They just sent a notice that the next upgrade will require
that the user have a DVD reader (as it would take too many CDs to
distribute this much information), Pentium 4 and minimum 512MB available
RAM (highly recommended 3 GB for good performance). 

Apparently, according to this company, the USPS has changed it
requirements for how programs designate their mailing codes and is now
forcing them to use the USPS database directly. (I could get the details
and post them if anyone is interested). Upon further investigation the
USPS database is approx. 3 GB. 

So my conclusion is that the only way this company's application runs
well with this new requirement is to load the entire USPS database into
RAM.

This requires a new XP workstation that will be the biggest, fastest
computer this clients owns - all for doing bulk mailings via proprietary
software and equipment. Previous to this upgrade they had been using the
lowest end XP workstation.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com