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

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.