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
jeffkwells2003Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MacroShadowCommented:
Are you a paying customer of Google? Free users only get 2400 requests per 24 hours.
0
jeffkwells2003Author Commented:
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
0
MacroShadowCommented:
Sorry, my bad it's 2500 for the free users.
To use your key you append it to the end of the request.
i.e.
https://maps.googleapis.com/maps/api/geocode/json?address=1600+Amphitheatre+Parkway,+Mountain+View,+CA&key=API_KEY

https://developers.google.com/maps/documentation/geocoding/intro

As far as pricing is concerned you will have to contact Google.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jeffkwells2003Author Commented:
Thanks a lot, that did the trick!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.