ASP prompts at least one parameter not specified value solution _ Application Tips

Error type:
Microsoft JET Database Engine (0X80040E10)
At least one parameter is not assigned a value.
Reason: When writing SQL statements, we often invoke some arguments, and it is possible that one of these parameters is not assigned a value.
Resolution: Check the value of each parameter is really passed over, it is likely that some parameters are actually "", such parameters to index the database is certainly not.

Detailed Source reference: http://www.jb51.net/article/26119.htm

Access at least one parameter is not a specified value workaround

Recently started with Access database, used to use MySQL and MSSQL, the results always appear "at least one parameter is not specified value" error, finally Baidu Search, found that this is the problem of SQL statements, is my database query statement after more written "ORDER by ID Desc ". Depressed. Powered by 25175.net
Later, this situation occurred, after the inspection found that a field name was wrong, alas ... Too careless, after a little more careful to write the program!!

Summarize:
This occurs mainly because the SQL statements we write do not correspond to the database fields or the fields in the table are not caused by:

SELECT * FROM MyTable where a= ' 1 ' and b= ' 1 '
But your mytable doesn't have a field.

The way to solve this problem is to carefully control the SQL statements and database tables ...