I've been experimenting with selecting data from database tables and trying to develop a work flow that allows me to select features from the tables without:
saving the db table as a csv,
importing the table to Arc,
saving the layer,
performing my selection,
exporting the table again,
importing the table back into my database.
Currently, I have my database table connected to arcgis and I have made my event layer from my database table. When I try to query my event, it won't let me. I can query the table, and make an event of the selection, but the event contains all the records and not simply the selected ones. It looks like I will still need to save my layer before making my selection, which is a messy pain. Does anyone know of a work around to doing these kinds of simple spatial queries that doesn't require me to have so much junk data to get my results.
I am using ArcView 10.0 and I have two database connections, one in SQL and the other in Access.