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:
Here's what worked:
I'm at a loss. Thanks for the help.
Randy
![[afro] [afro] [afro]](/data/assets/smilies/afro.gif)
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] [afro] [afro]](/data/assets/smilies/afro.gif)