I have an access database with 2 columns, a project number and the address; there's about 5000 records.
When working on a new project, many of the employees would like a way to determine if historically there are other projects that were done in proximity to their current project. In order to this I would have to have a way of searching through those 5000 records and somehow determining the closest projects based on the address they enter.
The only solution I found was to manually enter each address as a pin in Google Maps, they could then search the location of their project and then compare to the closest pins. Doing this with 5000 records is a terribly painful task, and the result will probably be difficult to handle for Google to display 5000 pins at once on screen.
I was wondering if there would be a simpler method using vb.net that does or doesn't necessarily involve a map?
All our projects are located in one city. Montreal, Canada