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 4 of 4

MapPoint via Access

This is a discussion on MapPoint via Access within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi All. Never been here before, but I hope you can help. I've been asked to launch MapPoint 2004 from ...

  1. #1
    DNA
    DNA is offline Junior Member White Belt
    Join Date
    Aug 2006
    Posts
    2

    MapPoint via Access

    Hi All.

    Never been here before, but I hope you can help. I've been asked to launch MapPoint 2004 from Access 2003 via VBA. No problem there, it's very straightforward.

    My problem however, is linking an Access Recordset to a MapPoint DataSet so I can use it in a DataMap. I know how to get data from an Access database, the problem is it's the database that's opened MapPoint (if you get what I mean). MapPoint can't open the database because it's already open.

    Is there any way I can assign an Access Recordset to a MapPoint DataSet without getting a 'Type Mismatch' error? (which is what happens when I enter objDataSet = RstCustomers).

    Any help would be greatly appreciated.

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi,

    I dont think you can do that because these are different objects. I think the way to go is to write a copy your data to another database or a csv file, and link mappoint to it.

  3. #3
    DNA
    DNA is offline Junior Member White Belt
    Join Date
    Aug 2006
    Posts
    2

    Smile

    Hmmn...

    If I export a copy of the appropriate Access Table (via VBA) as an Excel file then (from the same Module) I can open it in MapPoint using the LinkData method.

    Thanks,

    DNA.

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    I think it's an option in Access -- open database excusively or something like that, you would maybe just need to turn it off?

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. mappoint in access
    By nmilne in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 01-25-2006, 11:00 AM
  2. MapPoint with Access
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-26-2005, 12:25 PM
  3. Mappoint, SQL, and Access
    By wiljane3 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 03-11-2005, 02:46 PM
  4. Problem with mappoint in Access
    By Dazzer in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-04-2003, 05:27 AM
  5. MapPoint in MS Access
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 01-21-2003, 06:23 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