I am using arc10. I created some queries in MS access that I can open up in arcmap utilizing the database connections. It works fairly well but is rather slow. I wanted to know if there is a model that I could create, such that when arcmap is started, it would take the joined table from access and create a layer for the user to use as I think the connection from MS access query to arcmap 10 is making the process very slow. It works but if the table were saved as a layer it is faster. I could manually do it but if there is a way to automate the process that would be better as multiple users are involved. I'll try creating the model and seeing if I can get it to work.
The way to get Modelbuilder to add data to a map is to use the Make Table View tool from the Data Management Tools, Layers and Table Views.
In explanation, you must
- Have users provide a database connection, because it may be different on every machine.
- For the input table parameter, since you want to hard-code your model, use your database connection variable with the MSAccess query name. Per my example: AccessQuery = %Access Query Database Connection%/StationSeriesQuery for a query named StationSeriesQuery.
- To have the resulting table view layer load to the map, make sure you set the output table layer properties to be a model parameter and to "add to display".
One odd querk with modelbuilder and database connections I have found is that sometimes I have to cut and paste the connection from the catalog window because the dialog can't "find" my connections. That is, my only choice is to create another connection. If that happens, instruct your users to cut and paste it from the catalog window.
And here is the output: