I am using Mappoint with an application created in MS Access. All the data is kept in a MS SQL Server backend.
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...