Troubleshoot 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 at http://msdn.microsoft.com/support.

 

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 support@hostway.com 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
support@domains.verizon.net

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