Do you use the AllowZeroLength property on a field (Upsizing Problem)?
Last updated by Brady Stroud [SSW] about 1 year ago.See history- 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)?
- 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)?