This report will document all of the Forms and Reports in the database.The report will list the following properties of each object: This report will give a listing of all the Macro objects in the database.The report will also list any internal macro group names as well. The report will list the objects by category in alphabetical order and give a count of each type of object as well. This report will give a nice compact list of all the database object names.
UNPACK CSD FILES STEAM CODE
This report will list the total number of lines of code in each Form, Report, and Module.The report will also include a sub total for each Object Type and a grand total for the entire database.The report will be in a two column layout to minimize the number of pages. A count of the number of code bearing objects for each category will be given along with a total number of procedures for theentire database. The report will be in a two column layout to minimize the number of pages. This report will list each procedure name in every Form, Report, and Module in your database. The report will list the following for each Relationship found:įield names from both tables involved in the Relationship. This report will list all the Relationships defined in your database. The report will list the following field properties for any Lookups found:įield Name Row Source Row Source Type Bound ColumnĬolumn Count Column Heads Column Widths List Rows As long as you reallyunderstand what is happening behind the scenes with Lookup Fields then you should be Ok in using them. Lookup Fields can be misleading to people not familiar with the complexities of relational database theory. You can use this report to see if you would like to eliminate them from your database. This report will list all Lookup Fields in every table of the database. The Index Name will be listed and the field(s) that make up the Index. Each table will display the Primary and Foreign Key Indexes. What you do with these Indexes is up to you. The Indexes to Remove are ones that appear to be duplicates and are not really needed. 'Indexes to Keep' and 'Indexes to Remove.' The report will also analyze these Indexes and separate them into two categories: This report will list all Indexes in every table of your database and the Indexes' Attributes. The queries area of the report will list the Query Name, Description, Created and Modified dates, the SQL of the query, the Query Type, whether the query is Hidden, and whether the query is a RWOP query. The Subdatasheet property for each table (Jet 4.0 only) will also be listed. The path to each link table will also be provided and the report will also tell if the path is valid.
In addition, the table's Description, Created and Modified dates will be listed and the report will indicate if the table is linked. The report will also list the field(s) that comprise the Primary Key. The tables area of the report will provide a listing of all the table fields and the following properties of those fields: The CSD Tools - Version 2.0 Add-In for Access creates the following reports: Important - This add-in is not compatible yet with Access 2007.