MapPoint Forums

MapForums

Community of MapPoint and Virtual Earth Users and Developers




Datasourcemoniker issue with Access .mde file

This is a discussion on Datasourcemoniker issue with Access .mde file within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I have an Access process that imports a datasource from the current database I am using, eventually for use in ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Today's Posts Twitter Feed Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack (1) Thread Tools Display Modes
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 03-17-2008
Junior Member
White Belt
 
Join Date: Mar 2008
Location: Denver, CO
Posts: 3
Datasourcemoniker issue with Access .mde file

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 (by converting it to executible code), 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,
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 03-18-2008
Senior Member
Black Belt
 
Join Date: Nov 2004
Posts: 2,177
Re: Datasourcemoniker issue with Access .mde file

Hi,

I recall 4007 is 'unrecognised database format'. So you may be right about the unreadable format.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
access, datasourcemoniker, file, issue, mde


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/datasourcemoniker-issue-access-mde-file-7316.html

Posted By For Type Date
The Magazine for MapPoint - MP2K Magazine This thread Refback 03-18-2008 10:02 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
java issue Anonymous MapPoint 2006/2009 Discussion 1 03-01-2005 05:11 PM
Stored Procedure in DataSourceMoniker of ImportData medthod webjagger MapPoint 2006/2009 Discussion 2 06-25-2004 02:55 AM
vb6 server issue starbuck MapPoint 2006/2009 Discussion 1 04-15-2004 10:27 AM
to import data of one access file into another using vb code bushi_khan MapPoint 2006/2009 Discussion 0 10-14-2003 02:12 AM
[b]How do I export data into an ACCESS (mdb) file using VB6? rmozes MapPoint 2006/2009 Discussion 0 08-05-2003 08:17 AM


All times are GMT -5. The time now is 07:20 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0 RC2
MP2K Magazine
Visitor Map

Menorca Holiday
Enjoy a Menorca holiday at a great rate when booked through UlookUbook!



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59