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

Access and MapPoint control _really_ slow

This is a discussion on Access and MapPoint control _really_ slow within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi! I started using MapPoint when I had to create an application with it using Access. Now the application is ...

  1. #1
    dynek is offline Junior Member Yellow Belt
    Join Date
    Jan 2005
    Posts
    15

    Access and MapPoint control _really_ slow

    Hi!

    I started using MapPoint when I had to create an application with it using Access.
    Now the application is finished and it works well.

    We're importing excel files in access (that works just fine and fast).
    Then we take the info written in the DB (address, ...) to place the pushpins.
    The problem is that I have a query with 2700 rows and when I place these pushpins it's really slow. Like 10-15 minutes.

    Do you have any idea what could cause this or how I could speed it up ?

    I'd really appreciate your help. I'm in trouble if I can't get this to go faster!

    Thanks a lot

  2. #2
    John Meyer's Avatar
    John Meyer is offline Senior Member Blue Belt
    Join Date
    Jul 2002
    Posts
    478
    If you are not using the "ImportData method" (there is an geoImportAccessQuery flag) then try that method. I think you will lose the ability to show a progress bar but it will be faster.

  3. #3
    dynek is offline Junior Member Yellow Belt
    Join Date
    Jan 2005
    Posts
    15
    as long as it is faster I guess my bosses wont care of the progress bar. I'll just add a status bar saying if the work is finished.

    I'll have a look at this function now but I'll be able to code it in my app only on monday.

    Will I still be able to add different symbol and a legend to my points?

    Would you happen to have a quick example around?

    Thanks a lot for your help

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help please withActivex control and Microsoft Access VB bug?
    By Martin Neighbours in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-04-2011, 02:40 PM
  2. Using MapPoint control in MS Access
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 10-10-2005, 01:41 PM
  3. MS Access and Mappoint ActiveX Control
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 06-26-2004, 02:29 PM
  4. MapPoint Control 9 in Access 2000
    By TomBynum in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 05-28-2003, 03:51 PM
  5. Using MP ActiveX Control in Access/Foxpro etc
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-21-2003, 12:51 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 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96