Assessment Database Version 2 (ADB v.2) - Tools
The following tools are available for ADB v.2:
- Different versions of ADB v.2 are available; however, please note the Advantages of the Oracle version of ADB v.2.
ADB v.2 Installation Files for Windows XP and Earlier
The below zip files contain executable files that can be used to install the ADB v2.3.1. They contain all of the files needed to install the ADB, including both the application and database portion of the ADB. Steps are provided below to assist you with installing the ADB v2.3.1. Additionally, the ADB v.2 Users Guide can be downloaded from the ADB Reference section. Please review the ADB v2.3 release notes before you install the ADB v2.3:
Installation steps and files:
- Choose the zip file for the appropriate database format:
- To install the database, unzip the file you downloaded and double click on the .exe file.
- Open the ADB interface. Browse to the appropriate database file which contains your assessment information and select it to associate the database with the ADB interface.
- Chose a State and cycle.
- In the File dropdown list (located on the menu toolbar), choose the “Check for Update” option.
- Update the ADB to version 2.3.1 by following the steps listed in the Database, Tables and Software tabs in the Check for Updates window.
- If your state's designated uses have been loaded into the ADB, you will be ready to use the database once you complete the download. If your state's designated uses have not been loaded into the ADB, you will need to contact the ATTAINS help desk to get them added.
System Requirements
- Access version of ADB v.2:
- Windows 95, 98, NT, 2000, XP
- 20 MB Disk Space
- Note for users of Microsoft Access 2007 or higher: ADB for Access requires a .MDB Access file (Access 2003 format or lower). The ADB Access database itself should NOT be converted to Access 2007 format--users can open the database in Access 2007 but it should always be saved as an Access 2003 or lower database.
- Oracle version of ADB v.2:
- Windows 95, 98, NT, 2000, XP
- 20 MB Disk Space
- Oracle 8.1.x or higher client
- Oracle 8.1.x or higher Server
- 280 MB Disk Space
- SQL Server version of ADB v.2:
- SQL Server 7 or higher client
- Windows 95, 98, NT, 2000, XP
- 20 MB Disk Space
- SQL Server 7.0 or higher
- 280 MB Disk Space
ADB v.2 Installation Files for Windows 7
There are known compatibility issues with using ADB on Windows 7.
- ADB for Access - For the most part, the Access version of the ADB is compatible with Windows 7. There is a manual step that needs to be taken during the installation process. In addition, in the Validate Module, the log files do not open properly. Otherwise, there are no known issues. The Access database itself should NOT be converted to Access 2007--users can open the database in Access 2007 but it should always be saved as an Access 2003 or lower database.
You will need the Installation Guide, the Update zip file, and the appropriate ADB Installation file.- ADB for Access, Windows 7 Installation Guide
- The Update zip file - ADB_Access_Windows7.zip
- Access installation - Same as for Windows XP and earlier
- ADB for Oracle and SQL Server - In limited testing, issues were encounted with the Reports and Browse functions. However, we have heard of users who have not encountered these same issues. There may be additional compatibility issues with these versions.
You will need the Installation Guide and the appropriate ADB Installation file.- ADB for Oracle or SQL Server, Windows 7 Installation Guide
- Oracle installation - Same as for Windows XP and earlier
- SQL Server installation - Same as for Windows XP and earlier
Hydrography Event Management (HEM) Tool
The Hydrography Event Management (HEM) Tool is now available to create NHD events for various EPA programs.