[GIS] Embedding map into Access Database

ms accesssoftware-recommendations

I am developing a database for my organisation that could be spatially enabled.

I have to use MS Access 2007 on Windows and am therefore looking for any possibilities to incorporate my Access Database into a mapping tool to embed inside my Access application.

Has anyone successfully created an MS Access project which embeds a mapping window?

I would ideally like to simply geocode my datasets – digitize a point after inputting my data into the DB.

Best Answer

Use a Web Browser Control on your Access form. Then set the Control Source to (for example, using a text box on my form called txtTotalShops and a field called Address1)

="https://maps.googleapis.com/maps/api/staticmap&zoom=7&size=600x300&maptype=roadmap&markers=color:orange%7Clabel:" & [txtTotalShops] & "%7C" & Replace([Address1]," ","+") & ",NSW,Australia&key=AAAAAAAA"

You can change the zoom, size, markers etc as you wish (Note that the marker properties need %7C between them, other properties just an ampersand). Any spaces must be replaced with a plus sign (as in the example for Address1)

You can have up to 15 markers if you are using a human readable address (or unlimited if you use latitude and longitude)

AAAAA needs to be replaced with your own Google API key (free for 25,000 map loads per day)

If the whole statement becomes too long for Access, split it into several hidden text boxes on your form and then concatenate them (=txtWebAddress1 & txtWebAddress2 & txtWebAddress3) etc.

Full documentation (and instructions to get your API key) at https://developers.google.com/maps/documentation/static-maps/intro#Markers

Related Question