The Forest Service has the capability to access data residing in Oracle and other databases with Office 2000. Microsoft Access is part of the Office 2000 suite and has a strong ability to “link” to tables in other databases including Oracle. The purpose of this paper is to explain how to configure a PC for the linkage and illustrate how to make the connection. The primary benefit of using Access to manipulate data is its rich interface to quickly design queries, reports, and forms for data entry.

The connection is done through the use of a standard called Open Database Connectivity (ODBC). This is a specification for accessing relational database’s that has been in existence for many years.

Two additional software packages must be installed on the PC in addition to Office 2000. The software required includes SQL*Net (an Oracle product) and an ODBC driver (supplied by many software vendors). These additional software packages are already installed on Round 12 corporate PC’s as part of the software image. To get the software for earlier round PC’s, you must have your System Administrator schedule your PC for a software distribution from Missoula OSE (contact your System Admin). ODBC drivers for Oracle are included with the Office 2000 installation as well as from the Oracle package distributed by Missoula OSE.

Download pdf Linking Oracle Tables to Microsoft Access