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.