|
|
|
Software
- NPS Midwest Region GIS Custom Controls
AnalyzeRelations
Overview
Update: Both versions of this control have been updated to
work with tables that have GUIDs defined as their primary keys.
Please download and install the new versions if you are running
into problems with the current version.
AnalyzeRelations is a custom user interface control that can
be used helps check a database to ensure that referential integrity
constraints between related tables are maintained.
With this tool, a user is able to view and select from the
relations that have been defined between tables in the database.
The tool can then examine those related tables and determine
if there are records in the "child" tables that do
not have a matching related record in the "parent"
table. It can also examine the records in the "parent"
table to determine if there are records there that do not have
matching records in the "child" table.
This tool will output its results to the screen and can save
the results to a user-specified file.
Requirements
This control was written in VisualBasic 6.0 on Windows XP. The
ArcCatalog version has been tested and runs with ArcCatalog
8.3 and ArcCatalog 9.0 running Windows XP. The Microsoft Access
version has been tested and runs with Microsoft Access 2000
and 2003. It has not been tested on any other versions of Microsoft
Access, ArcCatalog or Windows. If you have troubles installing
or using this custom control please use the links below to contact
the author.
Download
The links below are to zipped folders that contain the full
source code of the AnalyzeRelations Visual Basic projects as
well as the compiled dlls. Click the link below for the version
(ArcCatalog or Access) of the tool you wand and then choose
"Save to disk" to obtain the folder.
Getting Started
* Download the item you want from the link above.
* Once downloaded, unzip the folder and save the contents to
a location of your choosing.
* To add the AnalyzeRelations control to a toolbar in ArcCatalog,
use the standard procedure for customizing toolbars in ArcCatalog.
For more detailed instructions, see the Customizing ArcCatalog
web-page for general instructions on how to install a custom
control in ArcCatalog.
* To add the AnalyzeRelations control to the Tools menu in Microsoft
Access using the stand-alone installer, double-click on the
"AR Setup.exe" program and the dll will install and
register itself on your system.Note, you must run the installer
as a user with administrative privileges. The add-in can be
uninstalled by using the Add/Remove program control panel.
* To add the AnalyzeRelations control to the Tools menu in Microsoft
Access manually, copy the downloaded .dll located in the Source
folder to a location of your choosing then run regsvr32 from
the command-line to register the .dll. Then re-start Access
(if necessary) and the control should be available for you to
use.
* There are also detailed instructions in PDF format on how
to install the AnalyzeRelations custom control included in each
downloaded folder.
Questions, Comments or Concerns?
You might wish to try visiting the Custom
Controls Troubleshooting web-page for assistance.
|
|
