Datasourcemoniker issue with .mde file

[jamcompany via AccessMonster.com]

I have an Access process that imports a datasource from the current database
I am using, eventually for use in MapPoint. Here's the code in question:

zDataSourceZ = Application.CurrentProject.FullName & "!qry_ZipData"
Set objDataSet1 = objDataSets.ImportData(zDataSourceZ, ,
geoCountryUnitedStates_Const, , geoImportAccessQuery)


This works if the database I am using is an .mdb However, if I make the
database an .mde, I get the following error when at the Set object line of
code:

Error number - 4007
Error Description - Cannot connect with the specified DataSourceMoniker.

The only thing that changes is the file extension on the current database--->
..mdb to .mde

Why? Does the ImportData method not work with .mde files? If not, what will
work with .mde files?

Thanks,

 

[jamcompany via AccessMonster.com]

Anyone have any ideas on this ???

Come on - there have to be some MS heavyweight MVPs out there who want to
take on a challenge!