U.S. Geological Survey Logo                                           Federal Highway Administration Logo

SELDM Version 1.0.0


Microsoft Access 2003 File Directory


index.html -- The table of contents for this CD-ROM

Microsoft Access 2000-2003 format notes:
These files are the primary SELDM files and have 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.

Please See:
  Software Disclaimer
  Copyright and License Information

Model Files in the Microsoft Access 2000-2003 format:
These model files are provided in a compressed Windows Zip file format
  Uncompiled 2000 -- Uncompiled Microsoft Access 2000 (mdb) file
  Uncompiled 2003 -- Uncompiled Microsoft Access 2003 (mdb) file
  Compiled 2003 -- Compiled Microsoft Access 2003 (mde) file
  DOT_FHWA.ico -- The model icon file FHWA Logo icon should be placed in the database directory

Visual Basic References in the Microsoft Access 2000-2003 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:

Access 2003 VBA reference window