Here is a complete working example (data & code) showing how to automate MapPoint from Access VBA.

AccessVBAExamples.zip

The code for the two functions - geocoding and calculating a distance matrix - are discussed in these articles --

Access VBA Programming Part I - Geocoding with MapPoint

Access VBA Programming Part II - Calculating a Distance Matrix

I don't have a form or macro's set up to run the code, but you can just open the respective modules, position the cursor within the Sub, and hit run.

Reply below if you have any questions.

Eric