The following table lists and provides possible solutions for some of the most common database errors. For more information on SQL database issues, visit Microsoft's support site.
| Error | Reason/Solution |
| Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. |
Cause: You don't have WRITE permission for the folder in which the Access database is saved. Solution: Obtain READ/WRITE permission for the folder/filename by contacting our Support team with the file name and location of that file. |
| Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. |
Cause: You may not have updated the database completely, You may not have write permissions to that database file. Solution: Obtain READ/WRITE permission for the folder/filename by contacting our Support team with the file name and location of that file. |
| Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same. /temp/errors.asp, line 9 |
Cause: In your SQL INSERT INTO statement, the number of the fields is not the same as the number of the values Solution: Make sure the numbers are the same and match each other. If the same, make sure you are not missing any commas in the query values. |
| Microsoft OLE DB Provider for ODBC Drivers error '80040e10' [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1. /temp/error.asp, line 14 |
Cause: Your SQL statement may contain an invalid field name in the WHERE clause or ORDER BY clause. Solution: Make sure there are no spelling errors. |
| ADODB.Fields error '800a0cc1' ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application. /temp/error.asp, line 15 |
Cause: SQL statement calls an invalid field name. Solution: Make sure there are no spelling errors. |
| ADODB.Field error '80020009' Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record. /temp/error.asp, line 15 |
Cause: Most of the time, you are referencing a field name after a SQL statement. However, your SQL statement didn't return any value. Solution: Before referencing a field, add "or" to avoid seeing this error |
| Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '...' /temp/error.asp, line 14 |
Cause: The apostrophe( ' ) in user input causes this error. Applies to any SQL statement dealing with data from user input. Solution: Use function InsertAP( ) to replace ' with ''. |