Microsoft KB Archive/90096

{|
 * width="100%"|

PRB: Update Queries Do Not Check Validation Rules
'Article ID: Q90096

Creation Date: 08-OCT-1992

Revision Date: 19-SEP-1996' The information in this article applies to:


 * Microsoft Access versions 1.0 and 1.1

SYMPTOMS

During update queries, validation rules are not checked, and no error log is generated for invalid records.

RESOLUTION

Run a query to see which rows violate the validation rules. For example, if you defined &quot;<500&quot; as the rule for the Units In Stock field in the Products table, and then ran an update query to update Units In Stock + 450, some of the fields might be greater than 500. You could then run a select query checking for Units In Stock > 500.

STATUS

This behavior no longer occurs in Microsoft Access version 2.0.

MORE INFORMATION

Update queries are queries that change existing data in a table. Validation rules are rules placed on a field when it is defined to prevent that field from accepting data that does not meet the specified rules.

When an update query is executed, as long as the data that is being changed is the correct data type for the field, it will be changed even if it violates the validation rules for field.

REFERENCES

Microsoft Access &quot;User's Guide,&quot; version 1.0, pages 174-178
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

Additional reference words: 1.00 1.10 update

KBCategory: kbusage

KBSubcategory: QryMktbl