When writing SQL statements, we often call some parameters. It is very likely that one of these parameters has not been assigned the wrong type:
Microsoft JET Database Engine (0x80040E10)
At least one parameter has no value specified.
Reason: When writing SQL statements, we often call some parameters, and it is possible that one of these parameters has not been assigned a value.
Solution: Check whether the value of each parameter is actually passed. It is very likely that some parameters are actually passed. Of course, it is not possible to index the database with such parameters.
Access at least one parameter has not been assigned a value solution
I just started using Access database recently. I used to use Mysql and Mssql before. As a result, there was always an error that at least one parameter was not assigned a value. Finally, I searched on Baidu and found that this was a problem with the SQL statement, which was my database query statement. I wrote more order by id desc at the end. Depressed. powered by 25175.net
This happened later. After checking, I found that a field name was written incorrectly. Alas. . . It's too careless. You have to be more careful when writing programs in the future! !
Summarize:
This situation occurs mainly because the SQL statement we wrote does not correspond to the database field or the field does not exist in the table:
select * from mytable where a='1' and b='1'
But your mytable does not have a field
The way to solve this problem is to carefully compare whether the SQL statement and the database table correspond...