DEVELOPMENT SERVER
Rules to Better Access Databases

SSW Rules/Reporting Solutions/Rules to Better Access Databases/Do you have invalid DefaultValue and ValidationRule properties (Upsizing problem)?

Rule #5

Do you have invalid DefaultValue and ValidationRule properties (Upsizing problem)?

v2.0 Posted at 20/10/2010 7:56 PM by system

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

Tell a Friend