MapForums
Community of VE/MapPoint Users and Developers
MapPoint via Access
This is a discussion on MapPoint via Access within the MapPoint 2006/2009 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 ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
08-24-2006
| |||
| |||
| MapPoint via Access 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.         |
|
08-25-2006
| |||
| |||
|
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.
__________________ rgds, Wilfried Mestdagh www.mestdagh.biz MapPoint coding demo Order MapPoint 2009 with Routing and User Tools Spreadsheet |
|
08-28-2006
| ||||
| ||||
|
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
__________________ |
 |
| Tags |
| access, mappoint |
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 |
| mappoint in access | nmilne | MapPoint 2006/2009 Discussion | 4 | 01-25-2006 11:00 AM |
| MapPoint with Access | Anonymous | MapPoint 2006/2009 Discussion | 0 | 03-26-2005 12:25 PM |
| Mappoint, SQL, and Access | wiljane3 | MapPoint 2006/2009 Discussion | 2 | 03-11-2005 02:46 PM |
| Problem with mappoint in Access | Dazzer | MapPoint 2006/2009 Discussion | 0 | 12-04-2003 05:27 AM |
| MapPoint in MS Access | Anonymous | MapPoint 2006/2009 Discussion | 0 | 01-21-2003 06:23 PM |
All times are GMT -5. The time now is 11:31 AM.
