Hi!

I'm looking for help for a curios problem.

To generate a couple of maps - each with different locations - I have the following loop in Access VBA:

While
Delete Dataset
Fill a table with locations
DataSets.ImportData (the table)
save the map
Wend

The problem is, that the Mappoint dataset always misses one recordset. It works fine, if i put a Stop in the code and continue manually:

While
Delete Dataset
Fill a table with locations
STOP
DataSets.ImportData (the table)
save the map
Wend

So, I guess, that the code is to fast and the work on filling the table is not really finished, when the table is imported.
Does anybody know, if there is a command like refresh or update the table, which I can insert before importing the table into Mappoint.

Any help is appreciated.

That's strange.

Maybe you can put in a wait statement just to pause for a second or two?

Also, maybe it is possible to populate multiple temporary tables first and then do the business of making maps after the temporary tables are finished populating?

good luck

Eric

Are you trapping exceptions? I've recently had a problem where I was able to feed data to Excel faster than Excel could handle it (Excel 2003, and if the user was scrolling/etc at the same time).
This threw back an exception that could be caught. If the error is the "edit in progress" error (in this example) then I paused 500ms and tried again. Otherwise I gave an error to the user.

Could it be something similar?

Also, if you're auto-generating the table, you could always kludge it with a dummy row!

Richard