ArcGIS to Access Link Tool

1
ArcGIS to Access Link Tool

• Originally presented by Angie Southwould
• Spatial Odyssey 2003
• Orlando, Florida

Danelle Malget GIS Specialist Natural Resource
Data Management Training Fort Collins, Colorado
2
What is Arc2Ax?

• The ArcGIS to Access Link provides aconnection
  between spatial data in an ArcGIS map and tabular
  data in an Access database.

3
Doesnt ArcGIS already do that?

• Yes
• ArcGIS will easily link to Access tables without
  the use of this tool

4
Doesnt ArcGIS already do that?

• and No
• ArcGIS will not link to Access forms and reports
  without programming

5
Is Arc2Ax the tool for you?

• Do you have tabular data stored in an Access
  database that is related to spatial data stored
  in an ArcMap map?
• Do you want to ability to query tabular data and
  view corresponding spatial data?

6
Is Arc2Ax the tool for you?

• Do you want the ability to run a spatial query
  and view corresponding tabular data?

7
Why use Arc2Ax?

• ArcGIS has limitations when viewing tabular data
• Access lacks tools to display spatial data
• This generic tool will link any database to any
  map that contains related data

8
How does Arc2Ax work?

• Arc2Ax.dll is registered during installation
• The Arc2Ax menu appears on all Access XP MDBs and
  all ArcMap MXDs.

9
How does Arc2Ax work?

• Create a link

10
How does Arc2Ax work?

• Activate a link

11
How does Arc2Ax work?

• When you run a link, queries are translated and
  exchanged between ArcMap and Access

Loc_Name HAVO-Low 1 OR Loc_Name HAVO-Low
2 OR Loc_Name HAVO-Low 3
12
Whats next for Arc2Ax?

• In testing phase
• Need to complete user documentation
• Wrapping up Beta testing
• Final release by early spring

Contact Angie_Southwould_at_nps.gov