MapForums
Community of VE/MapPoint Users and Developers
problem with linking to access
This is a discussion on problem with linking to access within the MapPoint 2006/2009 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 ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
06-16-2003
| |||
| |||
| problem with linking to access 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         |
|
06-19-2003
| |||
| |||
|
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. |
 |
| Tags |
| access, linking, problem |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Linking requests from access | dynek | MapPoint 2006/2009 Discussion | 1 | 01-10-2005 07:14 AM |
| Problem linking MApPoint DB2 - UDL | Anonymous | MapPoint 2006/2009 Discussion | 0 | 10-08-2004 09:19 AM |
| Linking access query results to MPC | Anonymous | MapPoint 2006/2009 Discussion | 0 | 06-22-2004 11:25 AM |
| I've got a problem when linking a dataset ! | Vincent BENNER | MapPoint 2006/2009 Discussion | 4 | 04-20-2004 08:19 AM |
| Problem with mappoint in Access | Dazzer | MapPoint 2006/2009 Discussion | 0 | 12-04-2003 04:27 AM |
All times are GMT -5. The time now is 09:43 AM.
