MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Access and MapPoint control _really_ slow

This is a discussion on Access and MapPoint control _really_ slow within the MapPoint 2006/2009 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 ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 01-07-2005
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 01-07-2005
John Meyer's Avatar
Senior Member
Blue Belt
 
Join Date: Jul 2002
Posts: 479
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.
__________________
John
http://www.support-pc.com

Order MapPoint 2006 Here
https://secure.mp2kmag.com/?refer=support-PC
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 01-07-2005
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Using MapPoint control in MS Access Anonymous MapPoint 2006/2009 Discussion 5 10-10-2005 12:41 PM
MS Access and Mappoint ActiveX Control Anonymous MapPoint 2006/2009 Discussion 3 06-26-2004 01:29 PM
MapPoint Control 9 in Access 2000 TomBynum MapPoint 2006/2009 Discussion 1 05-28-2003 02:51 PM
Using MP ActiveX Control in Access/Foxpro etc Anonymous MapPoint 2006/2009 Discussion 0 02-21-2003 11:51 AM
Help please withActivex control and Microsoft Access VB bug? Martin Neighbours MapPoint 2006/2009 Discussion 0 12-22-2002 03:44 PM


All times are GMT -5. The time now is 05:39 PM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Ski Spain
Ski in Spain to enjoy the rich culture and bustling restaurants and bars. Skiing in Spain is suitable for a range of standards and is great value when you book at Holiday Hypermarket.

Portugal Holidays
Find great Portugal Holidays with Travel Counsellors. A personal Travel Counsellor can help you plan the perfect holiday to Portugal.

Italy Holiday
An Italy Holiday is full of interesting stuff for the casual tourist and even more for the educated visitor. Check out the latest great deals at dealchecker.co.uk.

Dominican Republic Holidays
Dominican Republic holidays have something to offer for everyone. From water sports, to sun bathing and more, enjoy a holiday there!

Egypt
In Egypt you find an ancient city buzzing with life. There is an abundance of historical sites to see, not just the pyramids. The Opera House is certainly worth a visit and you can enjoy some open-air theatre too.

Bargain Holidays
To plan your holidays at bargain prices, use Travel.co.uk to explore all the possibilities.

Cheap Holidays in Lanzarote
Now's the time to get up and go visit the Canary Islands! View cheap holidays in Lanzarote only at On The Beach.


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