On Tue, 26 Jan 2010 19:55:13 -0500, "Gina Whipp"
wrote:


I include a City, State and FIPS Code table in all my databases so
the odds of them typing a City I don't have is a zillion to one.

However, unless you have such a table probably better to do it your way!

We don't normally include such a table because we don't want our
client to need to keep it up to date, their addresses are usually
quite localized anyway, and we don't usually need 100% accuracy (no
bulk mail). So our method works fine in *most* cases. In other cases
we've gone the other direction and written interfaces to
address-scrubbing APIs, so I see your point!

Cheers,

Armen Stein
Microsoft Access MVP
www.JStreetTech.com