Mapping Tools I Can Use With Access

[hullstorage]

Hi All,

Can anybody tell me if there are any mapping tools i can use with Access

Thanks

Simon

 

[StevenS]

There are probably a lot of tools that can do this; here are two I know

Open source or commercial

Open source:
MapWindow (for example click here)

Commercial:
MapX by MapInfo

 

[4L3X]

Yes, Microsoft Mappoint, you can link tables and queries to Access.HTH

 

[John Big Booty]

You should be able to open way points in Google Maps, this article may help

 

[hullstorage]

You should be able to open way points in Google Maps, this article may help

i have created a google maps account

but where do i go from here

cant find any information about access on link

thanks

simon

 

[Andrej]

If you need something more specialized you can connect ArcMap version 9.x with Access data base.

 

[StevenS]

MapInfo will also work with access by odbc-connection

 

[John Big Booty]

i have created a google maps account

but where do i go from here

cant find any information about access on link

thanks

simon

Still trying to find out how to do this with Google maps.

I have worked out how to do it in MultiMap

Use

http://www.multimap.com/maps/?zoom=16&countryCode=GB&lat=36.12625&lon=-5.345517

Just replace the lat/lon in the URL with the appropriate values for your location, and adjust the zoom to your requirements (a value of 19 seems to provide maximum zoom). This solution does not provide a place marker like Google Maps. However I'm pretty sure you should be able to do something similar for the Google Maps.

 

[John Big Booty]

Check this site you may be able to garner some info either from the code or the author.

I guess worst case scenario, is you could create a site similar to the one I've linked to above and put the lat/Long of the location into the the URL and open that from access. This site might also be useful.

 

[John Big Booty]

Try inserting your lat/lon into;

http://maps.google.com/maps?f=q&hl=en&geocode=&q=[B][COLOR="Magenta"]36.12625,-5.345517[/COLOR][/B]&ie=UTF8&ll=[COLOR="Magenta"][B]36.12625,-5.345517[/B][/COLOR]&spn=0.009697,0.013733&z=16&iwloc=addr

at the bolded coloured points. I have no idea what the other parts of the URL do.

This link should help you tweak the URL to show exactly what you want.

 

[John Big Booty]

I just found this description of how to open Google maps in a web browser embedded in an access form. I'm still playing with it and trying to get it working though.

 

[John Big Booty]

Got it working check the view all way points button.

 

[RexesOperator]

MapInfo will also work with access by odbc-connection

I use a simple approach - I save my access queries results as excel files and then open them from within MapInfo.

 

[John Big Booty]

Made a small tweak, know opens Google maps and multimaps in external browser or Google maps in a form embedded browser. Thanks Bob Larson.

 

[RexesOperator]

Re: Mapping Tools I Can Use With Access AWESOME!

First of all, do I have permission to use this in my existing database?

Secondly (assuming the answer is yes), to do so, do I simply import all the db objects as they are?

Finally - can more than one waypoint be viewed at a time?

 

[John Big Booty]

1. Yes, it's in the public domain here, so do as you will. Credit where credit is due keep in mind I have simply implemented code I found here. So that portion is not my own work.
2. Yes
3. In theory I'm guessing so. However at this point, I have no idea how to do so. Looks like some more research is required

 

[RexesOperator]

This is going to blow my manager away! Thanks for your hard work. I will be linking all code I got from this site into my documentation. So this location will be included as well.

 

[John Big Booty]

I'm very happy if it gets some real world use. There was some discussion in this thread regarding the accuracy of the distance calculation portion of the DB. However unless you are looking for pinpoint accuracy it should suffice for most purposes.

 

[RexesOperator]

I have a distance function that is part of a radial search functions that was developed by my department within a dbIII program. I adapted those functions to Access. So that's not an issue. The cool part is the direct link to GoogleMaps. That really helps with what we do.

 

[John Big Booty]

OK great.

If you are using the form embedded browser, I have discovered a small problem which I'm trying to solve here. If you are using the externally spawned browser, that works fine. If you are using firefox it opens in a new tab each time which is quite handy.