Last updated by SSW.Rules.SharePointExtractor on 22 Feb 2021 02:03 am (9 months ago) See History
Do you use the AllowZeroLength property on a field (Upsizing Problem)?
- The value that you select for the AllowZeroLength property determines whether zero length strings ("") may be inserted into a field. Currently, the Upsizing Wizard does not create a constraint or trigger against an upsized table to enforce this rule. Instead, you must manually create a Check Constraint on the columns once the upsizing process is complete.
- Still an issue in Access 2000 -2003
Upsizing PRO will check this rule
Do you use the Caption property on a field (Upsizing Problem)? Do you have invalid DefaultValue and ValidationRule properties (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)?