I have an Access file (*.mdb), and I want to join between this attribute data with its spatial data ? But other than (join & relate way) .
And I need it to be permanent .
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
You can perform permanent joins using the Join Field tool which:
Joins the contents of a table to another table based on a common attribute field. The input table is updated to contain the fields from the join table.
You did not mention which part of ArcGIS you have your join. In ArcMap, tabular joins are temporary by nature, To make a tabular join permanent you just need to export it to a new feature class.
If you are using the geoprocessing tools in the Toolbox (for Map or Catalog) or through python, you can use one of two methods. The 'Join Field' tool (under Data Management Tools/Joins) will update the input table to include the joined data. This alters the schema of your original data (there is no undo option).
The other method is to use the 'Add Join' tool (again under Data Management Tools/Joins) to create the join in memory like ArcMap's normal interface does and then use the 'Feature Class to Feature Class' tool (under Conversion Tools/To Geodatabase) to export to a new shapefile or geodatabase layer.