I'm developing an application in Microsoft Access 2000 which uses the mappoint activex control. The user selects a branch and the info to be displayed, the map then zooms to that branch and displays the chosen points around it.
I'm creating a new table in MS access for the data to be displayed and then using importdata to show it in the activex control.
The problem is that the first time I run this it works as it should, but then when I try another selection I get a message "the data necessary to complete this operation is not yet available".
Even stranger, when I put a message box on the screen with an o.k. box to click before executing the importdata command, the problem doesn't occur.
I've tried checking the readystate of the control, but this always seems to be 4. The table does seem to be available in MS access.
Any help would be very much appreciated.