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

I have tried for some time to link to data stored ....

This is a discussion on I have tried for some time to link to data stored .... within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have tried for some time to link to data stored in a secure Access database. I get the message ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    I have tried for some time to link to data stored in a secure Access database. I get the message 'There was a problem opening this file x:\test.mdb. The file is not in the expected format.'

    I am able to attach to unsecured datbases with no problems.

    I am using MapPoint 2002, but also had the problem in MapPoint 2001.

    Thank You

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    You've hit on a known limitation of MapPoint. The product will not allow you to connect to password-protected datasources.

  3. #3
    samoht is offline Junior Member White Belt
    Join Date
    Jun 2006
    Posts
    1
    I know this is 5 years old, but it is still a problem and this thread still shows up if you search for an answer.

    Anyway, the answer (now?) is to create a UDL file which points to your database, containing the username and password, and then link or import data with this UDL file, rather than the MDB directly. I found that using 'OLE provider for ODBC Drivers', building a connection string, saving the database password in the UDL file, and then entering the database name as the 'initial catalogue to use' allowed Mappoint to get into my database.

  4. #4
    WonderMonkey is offline Junior Member Yellow Belt
    Join Date
    Apr 2006
    Posts
    22
    Good information. Thanks for updating.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Link data problem
    By Athos in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 02-09-2006, 06:37 AM
  2. Link data to Goldmine
    By slanders in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 02-16-2005, 03:01 PM
  3. How can I refresh the data link from VB
    By flymoe in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 10-21-2004, 07:46 AM
  4. Stored Procedure in DataSourceMoniker of ImportData medthod
    By webjagger in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 06-25-2004, 03:55 AM
  5. Connection Time Out from "Post Reply Auto Email's Link&
    By JPeters in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 08-05-2002, 11:22 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 84 85 86 87 88 89 90 91 92 93 94 95 96