How do you connect and ArcGIS map to a Microsoft Access Database? The database has data on monitoring wells (i.e. water levels, chemical concentrations...ect) and the ArcGIS Map has well locations. Can I run queries on the database while working inside an ArcGIS environment?
Open Catalog. Go to Customize>Toolbars>Customize and search "Add OLE DB Connection". Drag this tool to a toolbar. Click on the icon for the tool. Select Microsoft OLE DB Provider for ODBC Drivers and hit Next. Select "Use Connection String" and hit Build then select Machine source and double click MS Access Datasource then hit the Database button and browse to your database. Hit Ok and Ok again and then hit Test Connection... hopefully it works... every time I do this it takes a few tries. I have also seen a way to build the connection string manually, but I can't remember the specifics