The Wood Database Grading Query Version 1.0
The grading program is intended for use by engineers or architects when assessing structural adequacy of wood members in historic buildings for their intended or anticipated use. The wood grading program is just one part of a structural assessment, however. The grading program user must conduct a condition assessment of the wood members as part of the process to determine the presence and significance of other potential grade limiting defects.
The wood grading program is called the Wood Database Grading Query Version 1.0, but is referred to as the “grading program” in this document. It was developed using Microsoft Access 2003. The directions found below allow you to open the database and query the program for the wood members you wish to investigate. Computers with Microsoft 2003 or later can access the program, although display and security settings may be slightly altered. The information you will need before you use the program includes the species of the wood members and their dimensions. Entering this information into the grading program will generate a table that you can use to assign a grade to the wood members. Remember that boards and structural light framing are not included in this program.
Because Microsoft Access 2007 has a number of security requirements that differ from Access 2003, certain steps need to be taken to ensure that the query will function properly. Computers running Microsoft Office 2003 or 2007 will be able to run the program; Computers with Microsoft Office 2000 or any other earlier version of Microsoft will not be able to access this program.
For Microsoft Access 2007 users, the following steps need to be completed prior to opening the database in order for the query to run properly:
- Open Microsoft Access.
- Click the Microsoft Office Button (upper left), and then click Access
- Click the Trust Center, and then click Trust Center Settings.
- Click Macro Settings.
- Click enable all macros (not recommended; potentially dangerous code
can run), and then click OK.
- Close all windows and close out of Microsoft Access, and then click to
open the Wood Grading Database Query.
As long as the database being opened is from a trusted source, enabling all macros will not harm your computer. However, you may want to re-establish the original security settings following utilization of the wood grading program if Microsoft Access is a commonly used program on your computer, as the security settings apply to all databases opened in Access.
The program then presents a welcome screen that provides some contact information and additional use information for the wood grading database and accompanying report. By clicking on the “Run Query” button, the user can begin the program.