Features

• Access version's two-digit year presumptions
• Window's date format settings

Database References to External Objects
Know all the external objects your database is using:

• Linked/attached databases
• ActiveX/OCX usage
• DLL references via Declare Statements
• Library references
• Files that are imported or exported

Table Structure Analysis
Understand your tables and their fields:

• Overview of each table, field, and data type
• List every Date/Time field with verification of field InputMask and Format settings for Year 2000
• Flag date related fields based on their field names

Data Analysis
Field analysis determines the minimum, maximum, and average of each field so you can verify and detect:

• Bad date data such as dates in the early 1900s
• Potential Date Data in Numeric Fields (Year, Month, Day)
• Potential Date Data in Text Fields (e.g. imported text YYMMDD)

Query Analysis

• Detect the use of date fields and suspected date fields
• Find Select queries that display (output) date fields
• Detect queries with criteria using dates and date ranges
• Flag usage of date functions (DateVal, CVDate, Year, etc.)

Form and Report Analysis

• Know which forms and reports use dates in their RecordSource
• Know which Combo Box and List Box use or display date fields
• Verify control InputMasks and Formats support Year 2000
• Verify control widths can display four-digit years without truncation or word-wrapping
• Find controls with date functions in their ControlSource
• Perform Control Analysis listing every control, ControlSource, InputMask, Format, Validation Rule and Validation Text, so you can find controls using dates

Macro Analysis
Make sure Macros are Year 2000 ready:

• Detect macros with date conditions
• Print outs of all macro lines or just lines with date issues

Module Analysis
Line by line analysis to detect words that are date related:

• Detect explicit dates
• Detect lines of code using date commands
• Detect variables defined as Date type (Access 97)
• Complete module printouts with or without date issues

Import/Export Analysis
Verify file import and export settings use four-digit years in date fields. By default, Access only uses two-digit years.

Complete Field Cross-Reference
Quickly see where every field and date field is used. A complete field cross-reference shows where every table or query field is used across all the queries, forms, and reports in your database.

Customizable String Search
A list of date related words are searched throughout your database for exact and partial matches. Find every use of words like "Date", "January", "Year", etc. Add your own words, and find every field name, control name, property, module line, etc. that uses it.