Article ID: 303414 - View products that this article applies to.
This article was previously published under Q303414
Novice: Requires knowledge of the user interface on single-user computers.
When you run an append query, you may receive the following error message:
Microsoft Access can't append all the records in the append query.
Microsoft Access set 0 field(s) to Null due to a type conversion failure, and it didn't add 0 records to the table due to key violations, 0 records due to lock violations, and <x> records due to validation rule violations.
Do you want to run the action query anyway?
To ignore the error(s) and run the query, click Yes.
For an explanation of the causes of the violations, click Help.
The message occurs when you try to insert empty strings into a field that has its AllowZeroLength property set to No.
Steps to Reproduce the BehaviorCAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
For more information about the AllowZeroLength Property, click Contents and Index on the Help menu, click the Index tab in Help, type the following text
allowzerolengthand then double-click the selected text to go to the "allowzerolength" topic. If you are unable to find the information you need, ask the Office Assistant.
Article ID: 303414 - Last Review: January 31, 2007 - Revision: 3.1