Rules to Better Access Databases

Microsoft Gold Partner Logo
Search Go Search
Rule #9
Do you use the AllowZeroLength property on a field (Upsizing Problem)?
  v3.0 Posted at 20/10/2010 7:56 PM by system
  • 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
 

Loading
Do you like this rule?
Loading
Do you follow this rule?
Loading

......