With regrads to my last question, we have drivers who drive selected routes , I was wondering if the end point of one road which will be stored in northing and eastings can be linked to the start point of teh next road so that we can have some idea of teh travelling time, this also needs to done through an access database.

It would seem that the easiest mechanism for this would be to just create a route which took all of the segments into account. If you create each stop point (Waypoint) in the route and then calculate the overall route, the driving time can be extracted from the Directions collection associated with the entire route or the SegmentDirections collections that are properties of the Waypoints.
See http://www.mp2kmag.com/mappointqa.asp?p=users&id=533 for more information on navigating the object model for routes.


Once calculated this can be stored in Access or returned to an Access form.


- Walt Cygan