Question: Hi I am using MSAccess (2003) and retrieving an XML recordset from an URL successfully in a macro.

The trouble is the macro and the vba seem to be asynchronous meaning I need a callback on the retrieved xml to continue processing it. I can seem to find anything on the net for a basic VBA callback (I have found stuff on dll's but I am not using these). Does anyone have the missing piece in my puzzle please?

```
Const acAppendData = 2

Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "C:\Scripts\Test.mdb"

objAccess.ImportXML "http://api.com/api", acAppendData

```

Answer: 
I was able to run the following successfully in Access:

```
Public Sub Test()
    Dim rs As DAO.Recordset
    Application.ImportXML "http://www.w3schools.com/xml/plant_catalog.xml", acStructureAndData
    Set rs = CurrentDb.OpenRecordset("PLANT")
    rs.MoveLast
    Debug.Print rs.RecordCount
End Sub

```

The .xml file is public, so you should be able to test this without modification.
A method I used to solving this was to use a do while loop querying the resultant table until a record count > 0 was returned and delaying each repeat by 1 second