MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




using access 2003 queries as a data source

This is a discussion on using access 2003 queries as a data source within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I have a database which when I connect to - the datamapping wizard can see tables, but when I try ...


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

using access 2003 queries as a data source using access 2003 queries as a data source

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


Notice: Now taking orders for MapPoint 2009!


Click here to register

Reply

 

LinkBack (1) Thread Tools Display Modes
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 04-24-2004
Junior Member
White Belt
  
Join Date: Apr 2004
Posts: 7
using access 2003 queries as a data source
I have a database which when I connect to - the datamapping wizard can see tables, but when I try to link to a query the query window is empty (the query runs ok in access).

Any ideas please?


Roberta
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 04-24-2004
Junior Member
White Belt
  
Join Date: Apr 2004
Posts: 7
using access 2003 queries as a data source
I have just answered my own question in case anyone is interested.

I had limited the dates showing in a date field using Like "*/*/2001" rather than Between 01/01/2001 And 31/12/2001. When I changed to the latter criteria it worked!!!!!

Roberta
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 04-27-2004
Senior Member
Black Belt
  
Join Date: Jul 2002
Posts: 5,138
Access Queries with wildcarded dates
Roberta

If you want to select all the dates within a single year, you might try using where year(date) = 2001

The function call may not be 100% accurate since I was replying off the top of my head but I believe a quick glance in the help should confirm the syntax. I was recently looking at some Access code I did in the 90s that used the year function and it seemed to work ok.

Best Regards
Anthony Case
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
2003, access, data, queries, source

« editing push pin and imported data | limiting objects in collection »

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/using-access-2003-queries-data-source-2759.html
Posted By For Type Date
*Clix This thread Refback 02-26-2007 02:05 PM

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

 
Thread Tools
Display Modes
Linear Mode Linear Mode

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
Custom Data source Anonymous MapPoint Web Service and Virtual Earth 2 08-11-2005 03:25 PM
Question about Map Data Source VincentSun MapPoint 2006/2009 Discussion 0 02-27-2005 08:37 PM
Which data source to use ? Anonymous MapPoint 2006/2009 Discussion 0 07-07-2004 05:03 AM
[VB6 + ACCESS + MP] : How to change data source ? Vincent BENNER MapPoint 2006/2009 Discussion 0 10-17-2002 02:35 AM
link data wizard won't let me use parameter queries Anonymous MapPoint 2006/2009 Discussion 7 08-23-2002 10:14 AM


All times are GMT -5. The time now is 01:24 AM.

Marketing Strategy - VSAT - Used Cars - Book a Hotel - Starcraft 2 - Archive - Top

Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Flights to Reus
Book cheap flights to Reus on Holiday Hypermarket for a fantastic holiday in Costa-Dorada! Great weather, great shopping and great beaches.

Personal Travel Agent'
Whatever your travel needs your personal Travel Agent can help. Travel Counsellors are a Queen's Award winning Travel Agent

Cuba Holiday
A Cuba Holiday has so much to offer with numerous different cultures affecting the sights, sounds and tastes. Visit this fascinating country with dealchecker.co.uk.

Holidays to Dominican Republic
Holidays to Dominican Republic offer a wealth of natural beauty and magnificent views. Come alive in the splendor of the Dominican Republic!

Holidays
For bargain holidays to destinations including Mexico, South Africa, India and more, visit ULookUBook online today. Check out our free travel guides to help you make an informed decision for your holidays.

Cheap Inclusive
Make use of our service at Travel.co.uk to help you to research cheap inclusive holidays.

Goa Holidays
Enjoy the warm and sunny climate of Western India. Visit On The Beach for information on Goa holidays.


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