The error "no search keyword found in all records" in access is fixed.
Source: Internet
Author: User
Microsoft Jet Database Engine error '20140901'
No search keywords are found in all records.
I started to debug whether it was a data error. I also clicked "compress and repair Database" for access many times, and there was a problem when I submitted the changes for the second time, later, I changed the information content to a few characters (just a few characters) and submitted it n times. I began to wonder if my access database was faulty. Baidu search Error CodeAnd found that there are quite a few such ArticleHaha, find the reason.
If the remarks field of access has an index, the record cannot be deleted when the content of the field exceeds 1908 bytes. It turns out that the information content field (that is, the remarks field) of the database does not know when the "Index" is added ". Change the index to "NONE.
It is depressing to create a remark-type field. Its default index is "NONE". I don't know when I modified the index type of the table or the access bug.
However, we can simply find a solution to this problem, and we will have another experience in the next programming and development.
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
