Do you use the AllowZeroLength property on a field (Upsizing Problem)?

Updated by Brady Stroud [SSW] 1 year ago. See history

123
  • 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

::: yellowBox Upsizing PRO will check this rule :::

acknowledgements
related rules