Access error solution for "No search keyword found in all records"
Updated: November 25, 2008 19:13:31 Author:
I haven't noticed it after writing asp for so long, but today I actually encountered it.
The web page is a modification submission of title and information content (remarks type). There is no problem with the first modification submission, but an error occurs when the second modification is submitted.
Microsoft JET Database Engine Error '80004005'
No search keywords were found in all records.
I started to debug if there was a data error. I also clicked Access's "Compression and Repair Database" many times. There was a problem when I submitted the second modification. Later, I used the information content to a small number of characters (regardless of characters). It was normal to submit N times. At first, I wondered if there was something wrong with my Access database. I searched the error code on Baidu and found that there are quite a lot of such articles. Haha, I found the reason.
If the access remark field has an index, the record will not be deleted after the content of the field exceeds 1908 bytes, and the above problem will occur. It turned out that it was the information content field (i.e. the comment field) of the database. I don’t know when the "index" was added. Change the index to "non".
What is very depressed now is to create a comment field, and its default index is "none". I don't know when I will modify the index type of overt table or the bug in Access itself.
However, just summarize and know the solution to such errors. Next time I will have more experience in programming and development.
No search keywords were found in all records.
I started to debug if there was a data error. I also clicked Access's "Compression and Repair Database" many times. There was a problem when I submitted the second modification. Later, I used the information content to a small number of characters (regardless of characters). It was normal to submit N times. At first, I wondered if there was something wrong with my Access database. I searched the error code on Baidu and found that there are quite a lot of such articles. Haha, I found the reason.
If the access remark field has an index, the record will not be deleted after the content of the field exceeds 1908 bytes, and the above problem will occur. It turned out that it was the information content field (i.e. the comment field) of the database. I don’t know when the "index" was added. Change the index to "non".
What is very depressed now is to create a comment field, and its default index is "none". I don't know when I will modify the index type of overt table or the bug in Access itself.
However, just summarize and know the solution to such errors. Next time I will have more experience in programming and development.
Related Articles
Chinese Access2000 Quick Tutorial--1.6 Defining "Primary Key"
Chinese Access2000 Quick Tutorial--1.6 Defining "Primary Key"...2006-11-11Two ways to batch replace database content in Access
In fact, SQL statements can be used to replace content in batches in the Access database, and the problem can be solved in just one sentence. The following are two methods to solve this problem.2010-06-06Access uses macro control program--1.6. Several explanations for using macros
Access uses macro control program--1.6. A few instructions on using macros...2006-11-11Access using query
Access uses query...2006-11-11Short int, long, float, double usage problem description
This problem is encountered when exporting Access data to DBF, the field width in DBF does not refer to the number of bytes occupied by the fields in Access, but the number of characters.2009-11-11Resolve an error that was not specified by Microsoft JET Database Engine (0x80004005) in Access
When we use the access database, we sometimes encounter unspecified errors of Microsoft JET Database Engine (0x80004005). Generally, this error is a permission problem. Today we will discuss the solution in detail.2014-11-11Use criteria for conditional query--1.5. Commonly used criteria expressions
Use criteria for conditional query--1.5. Commonly used criteria expressions...2006-11-11Chinese Access2000 Quick Tutorial--1.4 Use the "Table Wizard" to create a new table
Chinese Access2000 Quick Tutorial-1.4 Use the "Table Wizard" to create a new table...2006-11-11Use the criteria to conduct conditional query-1.3. Enter parameters before running the query
Use the criteria to conduct conditional query-1.3. Enter parameters before running the query...2006-11-11Solve the problem of grouping reports in Access
Solve the problem of grouping reports in Access...2006-11-11