MapForums
Community of VE/MapPoint Users and Developers
Mappoint, SQL, and Access
This is a discussion on Mappoint, SQL, and Access within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I am using Mappoint with an application created in MS Access. All the data is kept in a MS SQL ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-22-2005
| |||
| |||
| Mappoint, SQL, and Access I am trying to pull zip code-based territory info out of an SQL table and map it. Is there a way to connect to SQL Server other than using a UDL? I'd rather have the connection info stored in the code instead of having to create a UDL on the fly. Also, can user-defined functions be used as a recordsource? I have only been able to get tables and views to work so far... Thanks.         |
|
03-11-2005
| |||
| |||
| Don't use UDL
In Access, "Get External data - Linked" to an ODBC datasource that points to SQL Server. Then in Mappoint, just use the "Access" database you just created. |
|
03-11-2005
| |||
| |||
|
Hi, what is UDL ?
__________________ rgds, Wilfried Mestdagh www.mestdagh.biz MapPoint coding demo Order MapPoint 2009 with Routing and User Tools Spreadsheet |
 |
| Tags |
| access, mappoint, sql |
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 |
| MS Access Mappoint ActiveX | Anonymous | MapPoint 2006/2009 Discussion | 2 | 05-21-2005 06:31 PM |
| MapPoint with Access | Anonymous | MapPoint 2006/2009 Discussion | 0 | 03-26-2005 12:25 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:01 AM.
