ASP various error hint solutions

Error | Resolving Microsoft VBScript Compiler Error error ' 800A03F6 '
The required properties are not supported by the ODBC driver.
-------------------------------------------
Reason: Probably because there is no field name appearing in the SQL statement, typically a field name or SQL keyword writing error. It is also possible that the table being opened by SQL has been opened exclusively.
Workaround: Check each field name that appears in the SQL statement, and each keyword


====================================================microsoft OLE DB Provider for ODBC Drivers error ' 80004005 '
The user ' Admin ' on the machine ' hdzc-3jqskbwo02 ' locks the data table ' Order_Detail ' in exclusive mode.
-------------------------------------------------------------------
Reason: SQL required tables are open in table design form by Access
Workaround: Turn off table design


====================================================
Microsoft VBScript Compiler error ' 800A03F6 '
The item is not found in the collection that corresponds to the desired name or ordinal.
------------------------------------------------
Reason: No field name appears in SQL statement, typically a field name or SQL keyword writing error
Workaround: Check for each field name that appears in the SQL statement


====================================================
ADODB. Recordset error ' 800a0e78 '

Operation is not allowed when the object is closed.
-------------------------------------
Reason: The RS object was closed with Rs.close before rs.open the sql,conn,3,3 statement
Solution: Remove the previous rs.close


====================================================
Microsoft OLE DB Provider for ODBC Drivers error ' 80040e14 '

[Microsoft] [ODBC Microsoft Access Driver] Syntax error (missing operator) is in query expression ' OID form classtree where oid = 25 '.
--------------------------------------------------------------------------------
Reason: There is an English keyword or paragraph error in the SQL statement that is being written illegally
WORKAROUND: Type the SQL statement, and then check the words to find out the wrong writing.
-----------------------
Operation requires an updatable query
A: Look at the library file is not read-only.
Answer 2: The recordset (RS) ordered by is not allowed to have an update operation (rs.update)
---------------
3219 operation is not allowed in this content
Answer 3: Database field properties are set to allow null values to be inserted.
-----------------------------------
Aderrinvalidargument 3001
0x800A0BB9
The parameter used by the application is of a wrong type, is out of an acceptable range, or conflicts with other parameters.

Aderrnocurrentrecord 3021
0x800a0bcd
BOF or EOF is True, or the current record has been deleted. The operation requested by the application requires the current record.

Aderrillegaloperation 3219
0x800a0c93
The operation requested by the application is not allowed to appear in this context

Aderrintransaction 3246
0x800a0cae
An application cannot explicitly close the Connection object in a transaction.

Aderrfeaturenotavailable 3251
0x800a0cb3
The operation requested by the application is not supported by the provider.

adErrItemNotFound 3265
0x800a0cc1
ADO cannot find an object in the collection that corresponds to the name or order reference of the application request.

Aderrobjectincollection 3367
0x800a0d27
Cannot append, the object is already in the collection.

Aderrobjectnotset 3420 0x800a0d5c An object referenced by an application no longer points to a valid object.

Aderrdataconversion 3421
0x800a0d5d
The application used a value type that does not conform to the current operation.

Aderrobjectclosed 3704
0x800a0e78
If the object is closed, the operation requested by the application is not allowed.

Aderrobjectopen 3705
0x800a0e79
If the object is open, the operation requested by the application is not allowed.

Aderrprovidernotfound 3706
0x800a0e7a
ADO could not find the specified provider.

Aderrboundtocommand 3707
0x800a0e7b
The application cannot use the Command object to change the Recordset object's ActiveConnection property to its source data.

Aderrinvalidparaminfo 3708
0x800a0e7c
The application incorrectly defines the Parameter object.

Aderrinvalidconnection 3709
0x800a0e7d
An application requests an action on an object by referencing a closed or invalid Connection object.
--------------------------------
ADODB. One of the Field error ' 80020009 ' BOF or EOF is "true", or the current record has been deleted, and the required operation requires a current record.
Resolved as follows: This error is caused by the absence of a select, delete record, or the absence of a record in the library, so check the SQL statement, select, delete condition is correct, and before delete the best select a record or with on Error Resume Next .... On Error Goto 0来 processing. If it is because there is no record in the library, just add a judge if objrecordset.eof and Objrecordset.bof then is OK, because the pointer defaults to the top of the recordset when it is opened, so you can use only if Objrecordset.eof then to judge