SELDM Version 1.0.0

Microsoft Access 2007 File Directory

Microsoft Access 2007-2010 format notes:
These files are provided to help facilitate forward compatibility for SELDM in future years. The Access 2003 version of the model and installation package has been thoroughly tested with Microsoft Windows XP, Vista, and 7.

Note: The SELDM user interface and model code manipulate input and output data using the database objects. Commonly, data are manipulated using predefined structured query language (SQL) statements that explicitly manipulate tables and data fields by name using established database relationships between key fields. The design of the database is documented in appendix 3. It is highly likely that any database design changes to a compiled version of the model will render the model inoperable. Any change in the table names, field names, or database relationships must be accompanied by changes in the source code of an uncompiled version of the model in each place at which the VBA code interacts with that portion of the database. These changes must be extensively tested to ensure that the proper working relationships between the database and the code are maintained. Changes to the database design may result in unanticipated consequences in the GUI and in model results. Thus, the database design should not be modified at all, unless such modifications are made as part of a comprehensive and systematic redevelopment effort. Any code changes that are made anywhere in the code should be thoroughly documented using comment statements in the code. These comments should include information about the author of such changes, the date on which changes were made, and the reason for making the changes.

Note: The model has been run using the Access 2007 versions, but these versions were not tested exhaustively; there may be undiscovered incompatibilities with the model code in newer (post Access 2003) versions of the Microsoft Access database software.

Please See:
  Software Disclaimer
  Copyright and License Information

Model Files in the Microsoft Access 2007-2010 format:
These model files are provided in a compressed Windows Zip file format
  Compiled SELDM -- Compiled Microsoft Access 2007 (accde) file
  Uncompiled SELDM -- Uncompiled Microsoft Access 2007 (accdb) file
  DOT_FHWA.ico -- The model icon file should be placed in the database directory

Visual Basic References in the Microsoft Access 2007-2010 format:
The Visual Basic code modules need Access references, which must be set by opening the Visual Basic for Applications editor selecting tools then references. The reference window for this version of SELDM is:



The 2003 references also included the Microsoft DAO 3.6 object library, which did not load in the 2007 version. The DAO objects may be included in one of the newer libraries. However, the Microsoft DAO 3.6 object library may be necessary for some operations.