We help in programming Mappoint to run through SQL 2008 to determine distances and times between drivers and clients needing tranportation to appointments. Need to return best x cost effective options for selecting driver which will be returned in MS Access via called stored procedure. Then need to show, prefer on map, in MS Access, other clients needing tranportation to close by location, at the approximate same time, within the original route.
In addition, we'd like addresses validated at the point of entry and hope to utilize reverse Geocoding by storing the location values on SQL.
Mappoint 2010 (do not want to utilize web service) SQL 2008, Access 2007 (or higher), Windows 2008. Multiple users accessing through a terminal server connection.