Secret ingredients to quality software

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

Last updated by SSW.Rules.SharePointExtractor on 22 Feb 2021 02:03 am (9 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

Adam CoganAdam Cogan

We open source. Powered by GitHub