MartyConnelly
martyconnelly at shaw.ca
Fri Dec 3 13:01:23 CST 2004
You used to be able to screen scrape MapBlast site for this info, but Microsoft bought them up 3 or 4 years ago. You could also use the MS webservice site, so much per 1000 transactions rather than purchasing multiple copies of mappoint. Just don't forget all the oddities that will affect travel time. Here is an extreme one. To drive from Vancouver to Victoria the distance is only 60 miles, the actual driving time is an hour and twenty minutes However the total travel time is well over 3 hours due to the hour and half ferry ride. Then you have to switch your watch back 40 years to island time. MapPoint doesn't take these things into account John W. Colby wrote: >Does anyone have any experience automating mappoint using Access. I have a >client that wants to "staff contracts", and in order to do that they want to >visualize distances between the person's home address and the work address. >They also want to do things like ask mappoint to calculate distance / drive >time between a work address and a set of people home addresses, then hand >back to Access the data so that Access can display the data in a report >sorted on drive time / distance. > >Stuff like that. > >Does anyone have code that does this kind of stuff, or know of a web site or >user's group that I could go look at to start boning up on this stuff? > >John W. Colby >www.ColbyConsulting.com > >Contribute your unused CPU cycles to a good cause: >http://folding.stanford.edu/ > > > > -- Marty Connelly Victoria, B.C. Canada