Zip Code Radius lookup using Access and ASP

[jennas]

Hello,

We’ve been having a hard time using ASP to query a MS Access database for
zip code proximity information. There doesn’t seem to be any code compatible
with ASP and MS Access that can take a zip code and find all other zip codes
within a certain radius of the original zip code. There are quite a few
examples on the net, however they are only effective to around 50 miles or so
and then the results become full of false positives. Do you have any
information that you could offer that would help us to solve this problem? We
have two tables in our database that we will be using for this project. One
of them contains each zip code and its latitude and longitude. The other
table contains company information each with their own zip code. The ideal
solution would join the two tables on zip code and return all the results for
an X mile radius around the original zip code.

Note we know how to do this with SQL Server, but we need it for Access.

Any ideas?

Thanks,
Jenna

 

[AnExpertNovice]

I doubt it can be done with zip code alone. Search for Metropolitan
Statistical Area (MSA), FIPS, etc. These may lead you to a solution. In
fact, researching if either of those two (MSA will not!) would help you I
found software at www.zipcodedownload.com which may be of help to you. It
contains the following codes and more:
zip
city
county
county FIPS
state
state FIPS
MSA
Primary and Alternate Area codes
Time Zone
UTC shift
DST flag
Latitude
Longitude

 

[jennas]

Thanks for your reply. But unfortunately it does not help me. Actually we
already have and are using the zipcodedownload.com solution. The algorithm
needed to do the radius lookup we have which works in sql server does not
work in access because of limited functionality in access.

Any other ideas?