"No search keyword found in all records" solution (ACCESS database)

Source: Internet
Author: User
I was sorting out my blog yesterday. Article When you click an article to go to the details page, an error occurs: "No search keyword is found in all records". This error is not found when you click other articles to go to the details page, after searching online, find the following explanation:
Reference I searched the internet and found that this problem was a bug in the ACCESS database. The problem is that the table contains a remarks field.

Specific bug description:
Search for a text segment with more than 2 K bytes. In the remarks field, write Program Method or simply paste this field in the ACCESS database program, the first storage will certainly be normal. That is, it is normal to add and save for the first time. When the problem occurs for the second modification, you can modify or delete the remarks field either on the webpage or directly in the database, when saving, the system prompts "no search keyword is found in all records ". When this field is operated on, the webpage reports the "Microsoft Jet Database Engine error '80040e21', no search keyword found in all records" error.

When access creates a remark field, an index is implicitly added to this remark by default. We only need to delete this index. The method is as follows:
Go to the Access database,
Open the problematic table,
View --> Design view,
Then view --> index,
Delete the index of the problematic data item
Save



Open my database and find that the content field has not been indexed. I deleted all the indexes except the primary key index, and then saved them to access it.

Find another solution on the Internet. If you haven't tried it, write it down first:
When the referenced server encounters a power failure, access is allowed after the server is restarted, and an error occurs.
"No search keyword found in all records"
Then, the system prompts which logic on the page has a problem. The query logic has not changed. Check the data.
Search by Google,
Original
The access file is damaged.
Solution:
This error occurs because the ACCESS database has an error [database corruption],
Use MS access compression repair in access tools-> data plus utilities-> compress and repair Databases
The repair process is complete ~

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.