Do you have invalid DefaultValue and ValidationRule properties (Upsizing problem)?
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|
Do you use the AllowZeroLength property on a field (Upsizing Problem)? Do you use the Caption property on a field (Upsizing Problem)? Do you use the Format and InputMask properties on a field? Do you use the Required property on a field? Do you use a unique index and the Required property on a field? Do you have valid ValidationText property(Upsizing problem)?