Do you use the AllowZeroLength property on a field (Upsizing Problem)?
Updated by Brady Stroud [SSW] 1 year ago. See history
123
<introEmbed
body={<>
- 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](http://www.ssw.com.au/ssw/UpsizingPRO) will check this rule
:::
</>}
/>
Categories
Related rules
Need help?
SSW Consulting has over 30 years of experience developing awesome software solutions.