MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




MS Access-single data base/multiple Map categories

This is a discussion on MS Access-single data base/multiple Map categories within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I have been linking an Access data base to Maps and it works in general. I am having difficulty with ...


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

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  8 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 01-04-2007
John
White Belt
 
Join Date: Jan 2007
Posts: 1
Question MS Access-single data base/multiple Map categories

I have been linking an Access data base to Maps and it works in general. I am having difficulty with a specific link set up. My understanding is that MapPoint will link with Tables and Queries within Access. I have a data base of 400 records. I would like to map 5 different catagories of records out of this single data base. I have linked a filtered Query to the map and in the link wizard routine it shows only those records that are filtered in the Query but then it maps all the records of the data base

I am using a 60 trial version to demonstrate functionality prior to committing/deployment to MapPoint and as such MS does not provide any support, paid or otherwise.

So the question is: what is the best way to map multiple categories out of a single MS Access database. The location markers will be different color based on the category of the record.

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 01-05-2007
Senior Member
Blue Belt
 
Join Date: Dec 2002
Posts: 219
Re: MS Access-single data base/multiple Map categories

The easiest solution for you, at this time, would be to turn your query into a 'make-table' query and link to the table that gets created. You can still clear or alter the table and refresh the link afterward.
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


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/ms-access-single-data-base-multiple-map-categories-5549.html

Posted By For Type Date
A More Compact Method for Obtaining Lat/Long - MapPoint Articles - MP2K Magazine This thread Refback 01-17-2007 03:05 PM
MAPPOINT DOWNLOADS: License Agreement - MP2K Magazine This thread Refback 01-14-2007 03:00 AM
Using MapPoint in Foxpro - MapPoint Articles - MP2K Magazine This thread Refback 01-11-2007 02:27 PM
What's New in Streets and Trips 2006 - MapPoint Articles - MP2K Magazine This thread Refback 01-08-2007 06:15 PM
An API to Control MapPoint 2006 GPS Features - Part I of II - MapPoint Articles - MP2K Magazine This thread Refback 01-08-2007 04:09 PM
Microsoft MapPoint 2006 - MP2K Magazine This thread Refback 01-08-2007 11:34 AM
Windows Live Local Enhancements - MapPoint News - MP2K Magazine This thread Refback 01-06-2007 01:02 PM
The Magazine for MapPoint - MP2K Magazine This thread Refback 01-05-2007 10:37 PM

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
Importing a single BIZ in multiple states HELP needed kwcarlberg MapPoint 2006/2009 Discussion 3 11-03-2006 10:51 AM
Map points base map KevP MapPoint 2006/2009 Discussion 1 10-18-2005 05:36 PM
Mapping multiple 'groups' of data whs28175 MapPoint 2006/2009 Discussion 1 09-24-2003 08:20 PM
Base Meridian/Township/Range/Section data Anonymous MapPoint 2006/2009 Discussion 1 07-24-2003 04:15 PM
Update base map data using those in MS Steets & Trips Anonymous Wish List 0 12-18-2002 10:40 AM


All times are GMT -5. The time now is 10:44 PM.


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

Jersey Flights
Holiday Hypermarket should be your first choice for cheap flights. Book flights to exotic destinations or even just to Jersey.

Spain Weather
Check Spain Weather before you travel. We provide information on Spain including weather, flights and accommodation.

Cheap Flights to Cape Town
Here at dealchecker.co.uk we’ll shop around for cheap flights to Cape Town so you don’t have to. Find and Compare prices from over twenty UK travel agents with just one search.

Nile Cruises
Nile cruises are one of the best ways to discover the riches of Egypt. See ancient ruins and lush verdure from the River Nile. Book today!

Canaries
Find out all about the Canaries when you check out the ulookubook.com travel guides. Not only can you get a great holiday deal but you can find out useful information about potential holiday destinations.

Travel Guides
As far as travel guides are concerned, your best move would be to check out our website at Travel.co.uk

Cheap Holidays to Goa
Dine on delightful seafood in west India. Find information on cheap holidays in Goa at On The Beach.


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