Do you use the AllowZeroLength property on a field (Upsizing Problem)?
  v4.0 Posted at 11/09/2015 9:18 AM by William Yin
  • 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

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address: