How can I update Hydra data using Microsoft Access?
Microsoft Access is a useful tool for working with Hydra. You can use Access to edit or manipulate Hydra’s databases. This is especially useful for updating a few feilds in an existing Hydra layer, such as your SY_.DBF, or changing the ID numberings in source tables to be imported into Hydra using GIS Layer Transfer Wizard. Be sure to back up your data before attempting this! 1. Attach your Hydra .DBF file to the Access MDB by selecting File / Get External Data / Link Tables… 2. Create a new Query using Design View. 3. Add the appropriate tables to the Query, such as the source and target databases. 4. For a data join, create a link between source and target fields by clicking and dragging between them. 5. From the Query menu, select Update Query. 6. Drag the target field to the lower grid in the Query Design View. 7. In the “Update To” row, put the name of the source field. For example: “[mysourcedata]”, or “[my_id] + 10,000”. 8. From the Query menu, select “! Run”.
