AnsweredAssumed Answered

Using Address Locator in an MS Access database

Question asked by bulla_b on Feb 7, 2018
Latest reply on Feb 8, 2018 by bulla_b



I'm trying to figure out the best way to use an existing Locator service within an MS Access database for verifying that the address being typed in is actually valid.  Within my MS Access database I can retrieve the 'score' from the locator service using some code like this:


Private Sub Command0_Click()
    Dim httpReq As New MSXML2.ServerXMLHTTP
    httpReq.Open "GET", " Church Street, Ajax&outfields=Score&f=json"

    Dim response As String
    response = httpReq.responseText
    Set fs = CreateObject("Scripting.FileSystemObject")
    Set thefile = fs.CreateTextFile(Application.CurrentProject.Path & "\geo.txt", True)
    thefile.write (response)
    'MsgBox response
    'MsgBox Application.CurrentProject.Path
End Sub


Has anyone done this before?  I'm not totally sure of the best approach from here.  I guess I could scan the response to look for the score of all the matches, and let the user choose the best one??


I guess I'm just looking for some ideas.  The formatting of the JSON that comes back is a bit foreign to me and I'm not

sure of the best way to deal with it.


Here is a sample of what I am getting back from the service:


{"spatialReference":{"wkid":26917,"latestWkid":26917},"candidates":[{"address":"66 Church Street North, Ajax","location":{"x":656188.74132460123,"y":4857786.8273707693},"score":90.870000000000005,"attributes":{"Score":90.870000000000005}},{"address":"66 Church Street South, Ajax","location":{"x":656363.87805667717,"y":4857321.912464018},"score":90.870000000000005,"attributes":{"Score":90.870000000000005}},{"address":"66 Church St S, Ajax","location":{"x":656335.19874352403,"y":4857300.3138142293},"score":90.870000000000005,"attributes":{"Score":90.870000000000005}},{"address":"66 Church St S, Ajax","location":{"x":656337.24088169797,"y":4857318.2643990703},"score":90.870000000000005,"attributes":{"Score":90.870000000000005}}]}


Or is there a totally different, better way that what I am thinking??


Thanks for any input!!