I have an Access 2k database that I would like to add miles to using VBA and Mappoint 2k2. I have table field names for the origin and destination zips. Any suggestions or help would be appreciated.

Thanks.
Chris

Take a look in the Help file under programming.. you're going to use the Route object. You'd start by creating Location objects for the zip codes and Add-ing them to the WayPoints collection. Then you'll use the Calculate method and read the Distance property..