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 ::: </>} />

Acknowledgements

Adam Cogan
Related rules

Need help?

SSW Consulting has over 30 years of experience developing awesome software solutions.

We open source.Loving SSW Rules? Star us on GitHub. Star