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

Last updated by Brady Stroud [SSW] about 2 months 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

We open source. Powered by GitHub