Troubleshooting '0x80040E10', '0x800A0BCD','80040e14',and '0x800A0CC1' Error Message in Access Database

Error Message 1:

Too few parameters. Expected 1.Microsoft OLE DB Provider for ODBC Drivers (0x80040E10).[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
 
Solution:

This error occurs only with Microsoft Access when one of the field names used in a select statement does not exist in the table being queried.

Check that your SQL query is correct and that you have not misspelled any of the field names in your select statement and that the field name exists in the table being queried.


Error Message 2:

Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement.

Solution:

This error possibly related to corrupt number field or naming of fields in Access 97 Database and may be resolve by :

1.Rename field(s), or delete and recreate field.
2.Set all field types to "text." Use short field names, with no underscores, eg "curMonth"
Error Message 3:

Either BOF or EOF is True, or the current record has been deleted.ADODB.Recordset (0x800A0BCD).Either BOF or EOF is True, or the current record has been deleted.Requested operation requires a current record.
Solution:

This is a recordset error. It means that you have tried to read into a variable or display in a web page a record from the recordset that has either been deleted or does not exist.

The most common occurance of this error is if you have run a database query that has not returned any records and you have then tried to read in a record from the recordset that contains no data.


You need to first check that there is a record in the recordset before reading it in (eg. 'If NOT rsRecordSet.EOF Then').

Error Message 4: 

Item cannot be found in the collection corresponding to the requested name or ordinal.ADODB.Recordset (0x800A0CC1).Item cannot be found in the collection corresponding to the requested name or ordinal.
Solution:

This like the error above is a recordset error. You have tried requesting a field from the recordset that does not exist.

Check when you are reading in the field from the recordset into a variable or to display in a web page that you have spelt the field name correctly and that the field exists in the database.

Add Feedback