Troubleshoot Windows Database Errors

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 ''.

 

BACK TO TOP


Was this article helpful?
0 out of 0 found this helpful

Have more questions? Contact our support instantly via Live Chat