Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automating MS MapPoint

Status
Not open for further replies.

Elysium

Programmer
Aug 7, 2002
212
US
To all:

From what I've seen, there's very little descriptive (i.e. helpful) documentation on the MapPoint Object Model and I'm stuck right now. I have successfully created links to an Excel sheet(s) and created a DataMap and DataSet. However, if I try to link to an Access DB table, I get the following error message:

"Cannot import data because a connection to the database could not be established."

Here's some background info:
- The db is NOT password protected
- There are no funky characters in the DB or table names
- The path for the db is provided correctly

Any ideas on what could be wrong? Here's where the code is failing:

Code:
Set oTerritory = .ImportTerritories("D:\BTT.mdb!ALAZips", , geoCountryUnitedStates, , geoImportAccessTable)

Here's what worked:

Code:
DSM = FilePath & "!" & TerritorySheet & "!" & Territory_DataRange
Set oTerritory = .LinkTerritories(DSM, "PSL_CD", arTerritory, geoCountryUnitedStates, , geoImportAccessTable)


I'm at a loss. Thanks for the help.

Randy
[afro]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top