Mapping Tools I Can Use With Access (1 Viewer)

hullstorage · Nov 20, 2008

Hi All,

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

Thanks

Simon

StevenS · Nov 20, 2008

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 · Nov 20, 2008

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

John Big Booty · Nov 20, 2008

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

hullstorage · Nov 21, 2008

John Big Booty said:
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 · Nov 21, 2008

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

StevenS · Nov 21, 2008

MapInfo will also work with access by odbc-connection

John Big Booty · Nov 22, 2008

hullstorage said:
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

Code:

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 · Nov 22, 2008

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 · Nov 22, 2008

Try inserting your lat/lon into;

Code:

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 · Nov 23, 2008

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 · Nov 23, 2008

Got it working check the view all way points button.

RexesOperator · Nov 23, 2008

StevenS said:
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 · Nov 23, 2008

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 · Nov 24, 2008

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 · Nov 24, 2008

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.
Yes
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 · Nov 24, 2008

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 · Nov 24, 2008

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 · Nov 24, 2008

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 · Nov 24, 2008

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.

Mapping Tools I Can Use With Access (1 Viewer)

Registered User.

Registered User.

MOUS

AWF VIP

Registered User.

Registered User.

Registered User.

AWF VIP

AWF VIP

AWF VIP

AWF VIP

AWF VIP

Attachments

Registered User.

AWF VIP

Attachments

Registered User.

AWF VIP

Registered User.

AWF VIP

Registered User.

AWF VIP

Similar threads

Users who are viewing this thread