Microsoft Access is not case sensitive, but DBMS like DB2 and Oracle are. For example, a query specifying “abc”, “AbC” or “Abc” will match a data field containing “ABC” with Access. Only exact matches will return rows with DB2 or Oracle.
The Case Sensitivity Assistant identifies string comparisons in all Access query expressions that may not evaluate properly after migration. The wizard optionally updates table field data to upper or lower case, modifies query expressions accordingly, and creates DBMS triggers that ensure case consistency on all future inserts and updates.
Press the button to the left of the Source Table to display the queries that contain the Source Field and the expressions that compare the Source Field with string constants.
Source Table
The underlying table that contains the Source Field.
Source Field
The name of the underlying Text or Memo field that is used in the query's selection criteria.
Expression Occurrences
The number of expressions that compare the Source Field with string constants.
Update Case To
Used in conjunction with the global Update Case button at the bottom of the form, you can choose to convert the Source Field data to upper or lower case and optionally modify query expressions, and create triggers that ensure all inserted and updated data conforms to the specified case rule.
Completion Status
The completion status is used to track the progress you have made in rectifying case sensitivity issues. There are three options: No Action, Resolved, and Needs Review. The default is Needs Review. After an automatic case update is performed, it is set to Resolved. You can manually set it to No Action after reviewing each expression containing the Source Field and determining that case comparisons are consistent with the Source Field's data.
Press the button next to Completion Status to display the form that implements case rules. You can automatically update the Source Field data to upper or lower case, or choose to globally search and replace data in a format of your choosing.
Global settings and buttons:
Press this button to display detailed information relating to all Source Fields used in query expressions containing string comparisons.
Update Query
Choose Yes to update the query criteria to conform with the case rule when automatically updating to upper or lower case.
Set all case updates to
Sets all Update Case To fields to Upper, Lower, or None.
Completion Status Combo Box
Choose Needs Review, No Action, or Resolved from the combo box to filter Completion Status entries or choose All to list all entries.
Press this button to display the log of all case-sensitivity updates made to this database.
Press this button to initiate the update of all specified case rules.