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

Mappoint, SQL, and Access

This is a discussion on Mappoint, SQL, and Access within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am using Mappoint with an application created in MS Access. All the data is kept in a MS SQL ...

  1. #1
    wiljane3 is offline Junior Member White Belt
    Join Date
    Feb 2005
    Posts
    1

    Mappoint, SQL, and Access

    I am using Mappoint with an application created in MS Access. All the data is kept in a MS SQL Server backend.

    I am trying to pull zip code-based territory info out of an SQL table and map it.

    Is there a way to connect to SQL Server other than using a UDL? I'd rather have the connection info stored in the code instead of having to create a UDL on the fly.

    Also, can user-defined functions be used as a recordsource? I have only been able to get tables and views to work so far...


    Thanks.

  2. #2
    bhoffman67 is offline Junior Member White Belt
    Join Date
    Mar 2005
    Posts
    1

    Don't use UDL

    In Access, "Get External data - Linked" to an ODBC datasource that points to SQL Server. Then in Mappoint, just use the "Access" database you just created.

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

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. MS Access Mappoint ActiveX
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 05-21-2005, 06:31 PM
  3. MapPoint with Access
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-26-2005, 12:25 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