Home
Do you have invalid DefaultValue and ValidationRule properties (Upsizing problem)?
  v3.0 Posted at 11/09/2015 9:18 AM by William Yin
When you upsize a table, the Upsizing Wizard tries to "map" Visual Basic for Applications functions in your DefaultValue and ValidationRule properties to an equivalent TSQL function. If this attempt is not successful, the validation rule or default will be skipped by the Upsizing Wizard. Consider the following:
  • If the Upsizing Wizard fails to map a function in a field's ValidationRule property, only the validation rule is skipped, and the rest of the table is upsized.
  • If the Upsizing Wizard fails to map a function in a field's DefaultValue property, the entire table is skipped.
  • Access 2000: Validation rules are not upsized

Upsizing PRO will check this rule

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:

    Comments: