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

problem with linking to access

This is a discussion on problem with linking to access within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi. I hope somebody can help me. I'm building a simple DBase in Access with routes. I created a query ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    problem with linking to access

    Hi.
    I hope somebody can help me. I'm building a simple DBase in Access with routes. I created a query that showes my daily route based on locations table. When I try to link to it from Map Point I do not see my query as one of the choices. Any ideas? I'm using Map Point 2001.
    Gets even more interesting. Sometime I see my query and when I link to it , it does not work. Map Point is mapping all my Locations. The query does work, I can export it into Excel and then Map Point will map it from Excel. Please help, I'm running out of ideas and I have to go back to my boss with finished DBase soon.
    Thank you
    Barb

  2. #2
    jia_1980 is offline Junior Member White Belt
    Join Date
    Jan 2003
    Posts
    6
    Hello, Barb:
    After reading your post, I did a test. This is what I did:
    1. Create a database by using MS-Access, and create a Query;
    2. Create a UDL file to link the access database: I think maybe you already knew how to create a UDL file: create a blank file(any type is fine), then rename it as .UDL type;
    3. Adjust a UDL property: right click the file -> Properties; goto "provider" and select Microsoft Jet OLE DB provider; goto "connection" to select your database, if it has password, input it; don't forget to test it :)
    4. After that, you can link the query to mappoint by using Link Data Wizard, and it's done.

    I am using OfficeXP and Mappoint 2002, so hopefully, this is workable on mappoint2001.
    Hoping it is helpful.
    Good Luck.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Linking requests from access
    By dynek in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-10-2005, 07:14 AM
  2. Problem linking MApPoint DB2 - UDL
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-08-2004, 09:19 AM
  3. Linking access query results to MPC
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 06-22-2004, 11:25 AM
  4. I've got a problem when linking a dataset !
    By Vincent BENNER in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 04-20-2004, 08:19 AM
  5. Problem with mappoint in Access
    By Dazzer in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-04-2003, 04:27 AM

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