"Microsoft Office Access cannot append all records in the append query. Microsoft Office Access Field 1 is set to null because the type conversion fails and it does not add 0 records

Source: Internet
Author: User


When I use C # To save an access data, the system prompts that the data types are inconsistent.



When data is stored

An error occurred.

"Microsoft Office Access cannot append all records in the append query.


Microsoft Office Access Field 1 is set to null because of type conversion failure. It does not add 0 records to the table because of key-value conflicts. 0 records are not added because of lock conflicts, no Zero record is added because the validity rule conflict.

Do you want to perform an action query?

To ignore errors and perform queries, click yes "."



It cannot be solved, because all data is obtained through a function. If it cannot be saved, it cannot be saved. The type should be "OK", Google.

Sadly, none of the solutions work. Ignore him first and experiment with existing data. Two days later, when I added a new field, I still looked like a new one. I thought that the "long integer" data was too big and it was set to "integer" (I thought that the span of 2 was the power of 32, sadly, error source.


Therefore, if you want to manually add a number of 106000, an error is returned. Mlgb, and so on. Check "integer". Check that access "integer" spans the 16 power of 2, not the int in nndc #, but short! @ # ¥ % ...... & * () -- +


For a moment, I thought it had hurt me for a few hours! Therefore, we hope that similar people will learn the lesson.






Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.