asked on

Using the Google API to generate Latitude and Longitude values

I've been working on an Access database application which calls the Web Browser with a Google Map with multiple addresses marked upon it. I have been making progress by using UK Post Codes to generate Lat/Lng values via a routine I found on the Web which calls the Google Geocoder API. This was working fine until an hour ago. Now, no Lat/Lng values are being produced and when I use this hyperlink in VBA (strAddr can contain any address)

"http://maps.googleapis.com/maps/api/geocode/xml?address=" & strAddr & " & "sensor=false"

it returns a message saying "You have exceeded your daily request quota for this API"

I have only made a few thousand calls to the API key in the last 24 hours so I assume that t I am 'sharing' the software with other users. I assumed I needed an API key so I have obtained one from the Google Developers console. But how do I use it in my Access application? This is the key.

AIzaSyDx28H0H5KgitOSi-jhjNqXHeY3NA_7Cbo

Thanks

Joe Howard

Are you a paying customer of Google? Free users only get 2400 requests per 24 hours.

jeffkwells2003

ASKER

I didn't see that number on the Google Developers' site - they seemed to be talking about 25000 accesses per 24 hours! Any idea how much I (or my client) will have to pay?

And what do I do with that key I obtained for free?!!!

Thanks

ASKER CERTIFIED SOLUTION

Joe Howard

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jeffkwells2003

ASKER

Thanks a lot, that did the trick!