AutoCAD MAP AND ACCESS DATABASE

[Goldhound]

Question?

  Is it possible and if so how...

  If i connect to an Access Database and link to the blocks in my drawing, Can i have the drawing only show the blocks that i have quried in my database or does it just highlight the data in the database?

[bandit1965]

I use an Access Database. I can query only those objects asked for into a drawing or I can highlight those entries in the database by selecting the centroid or block in my base drawing. So the short answer is yes, if I am reading your question right.

[Goldhound]

Thanks, I know i can highlight the records but i am not sure how to display on the map only the blocks that i queried.

Example, I have 200+ thousand blocks plotted on my map and each one represents a seperate item. I have all blocks linked to my Access Database..

  Say i query only the blocks that represent a blue item and say there are 25 blocks that equal this. Out of the 200+ Thousand blocks in my drawing.. all that is displayed on the screen is what is in my query, the 25 blue blocks...

  This is what i want to be able to do...

any ideas?

[bandit1965]

Yes, if the data in the Access database has that detail in one of the fields. You can load the topology for that drawing and execute your query based on the data you want shown.

[Murph_Map · Accepted solution]

Create a new Map from the display manager, Add data based on a query.

[Goldhound]

Thanks!!!

Sometimes you cant see the forest for the trees.....