Hi All.

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.

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.

Hmmn...

If I export a copy of the appropriate Access Table (via VBA) as an Excel file then (from the same Module) I can open it in MapPoint using the LinkData method.

Thanks,

DNA.

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