Integrating Access with Map Point

[PieterLinden via AccessMonster.com]

Maybe I should preface this with "greetings from post-diluvian Nashville"...

Just wondering if anybody has successfully integrated Access with MapPoint.
Since I need something to learn, I was going to enter a bunch of addresses in
Access and then see if I could automate the mapping in MapPoint.

Any good pointers or resources on this? I found one book on automating
Mappoint, but it uses C#.... Can this still be done through VBA?

Thanks,
Pieter

 

[microsoft]

I did some intial playing around with it 5 years ago. Like most things, find
documentation on the MapPoint Object Model. Fundamentally, its just like
automating Outlook from Access or Word from Outlook, etc. You just need to
know the various objects, properties and methods. On a side note, my current
project will result in the need to generate directions between two known
points for which GPS coordinates are available. We'll be creating URL's to
feed to IE to query Mapquest.com. The documentation on mapquest seems pretty
straighforward.

 

[Tom van Stiphout]

On Wed, 26 May 2010 17:02:10 -0400, "microsoft"

The Bing API is not bad either. Worth a look.

-Tom.
Microsoft Access MVP

I did some intial playing around with it 5 years ago. Like most things, find
documentation on the MapPoint Object Model. Fundamentally, its just like
automating Outlook from Access or Word from Outlook, etc. You just need to
know the various objects, properties and methods. On a side note, my current
project will result in the need to generate directions between two known
points for which GPS coordinates are available. We'll be creating URL's to
feed to IE to query Mapquest.com. The documentation on mapquest seems pretty
straighforward.

 

[PieterLinden via AccessMonster.com]

The Bing API is not bad either. Worth a look.

-Tom.
Microsoft Access MVP

I did some intial playing around with it 5 years ago. Like most things, find
documentation on the MapPoint Object Model. Fundamentally, its just like

[quoted text clipped - 19 lines]

Thanks, Tom. Do you know if I can automate it using VBA or do I have to use
a .NET language?
I found only one book published on it, and it used C#, I think, to do the
automation.

Pieter

 

[Tom van Stiphout]

On Thu, 27 May 2010 04:21:50 GMT, "PieterLinden via AccessMonster.com"

Some of the technologies can be used from Javascript:
http://msdn.microsoft.com/en-us/library/bb429619.aspx
This may be all you need, depending how advanced your solution needs
to be. Some other options such as Silverlight require .NET
programming.

-Tom.
Microsoft Access MVP

The Bing API is not bad either. Worth a look.

-Tom.
Microsoft Access MVP

I did some intial playing around with it 5 years ago. Like most things, find
documentation on the MapPoint Object Model. Fundamentally, its just like

[quoted text clipped - 19 lines]

Thanks,
Pieter

Thanks, Tom. Do you know if I can automate it using VBA or do I have to use
a .NET language?
I found only one book published on it, and it used C#, I think, to do the
automation.

Pieter