Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

Problem with ImportData - Access to fast?

This is a discussion on Problem with ImportData - Access to fast? within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi! I'm looking for help for a curios problem. To generate a couple of maps - each with different locations ...

  1. #1
    stan is offline Junior Member White Belt
    Join Date
    Jul 2006
    Posts
    2

    Problem with ImportData - Access to fast?

    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.

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    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
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    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
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Fast way to add radius?
    By nomad_33fw in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-10-2005, 08:55 AM
  2. How to choose Fast, Short or Preferred itineray
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-10-2004, 04:14 AM
  3. Problem with mappoint in Access
    By Dazzer in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-04-2003, 05:27 AM
  4. Is there a fast way of adding pushpins?
    By matt1168 in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 07-24-2003, 10:44 AM
  5. problem with linking to access
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-19-2003, 06:32 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25