When you upsize a table containing a field with the AllowZeroLength property set to No, the Microsoft Access 2000 Upsizing Wizard does not create a trigger or CHECK constraint in an attempt to enforce the rule.
Open the Employees table in Design view, and examine the properties of the LastName field. Note that the AllowZeroLength property is set to No.
Close the Employees table.
On the Tools menu, point to Database Utilities, and then click Upsizing Wizard.
On the first screen of the wizard, click Create new database, then click Next.
Specify a Server Name, Login ID, Password, and Database Name in the boxes provided. Click Next.
In the Available Tables list, click Employees, move it to the Export to SQL Server list, and then click Next.
Accept the default options and click Next.
Select the Create a new Access client/server application option. In the ADP File Name box, type C:\AccessCS.adp, and then click Finish.
NOTE: You will encounter multiple errors during the upsizing process. This is expected. Click OK each time that you are prompted.
When the upsizing process is finished, close the Upsizing Wizard Report. The Access project, AccessCS.adp, created by the wizard should start.
In the newly created Access project, right-click the Employees table and click Triggers.
Examine both the Employees_ITrig and Employees_UTrig triggers, and note that neither contains SQL prevent zero length strings from being used in the LastName column.
Open Employees in Design view, right-click inside the Table Designer, and click Properties.
On the Tables tab, note that no CHECK constraints have been created to prevent a zero length string from being used in the LastName column.
For more information about constraints, see the SQL Server "SQL Server Architecture," in SQL Server Books Online. To download the SQL Server Books Online, please visit the following Microsoft Web site:
Back to the top
