Knowledgebase: Access Databases
Access error messages
Posted by Nexus Support Admin on 11 April 2004 07:27 PM
#1 : Cannot update. Database or object is read-only Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.

By far this is the most common error message that our customers run into. This error happens when you try to insert data into or update a Access database. The reason that you have received this error message is that you have uploaded your database for the first time or overwrote the copy that was originally there. Once you upload or replace an Access database we need to be notified so that we set the appropriate permissions on the database to allow for updates or inserts. Once you have the database uploaded, email our technical support group with your pertinent information and we will apply the necessary permissions needed so you can perform the updates on your databases.

#2 : Operation must use an updateable query Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

This error is directly tied to the item listed above. If you are receiving this error then the adequate permissions are not set on the database. Please contact the technical support group so that the appropriate permissions can established.

#3 : General error Unable to open registry key Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6cc Thread 0x78c DBC 0x144cfc4 Jet'.

This error can happen for a number of reasons, but the main reason being if the path to the database is incorrect. When having a DSN created ensure that you provide the appropriate path to the database -- example:

D:\inetpub\wwwroot\example\db\access.mdb.

#4 : Too few parameters. Expected 1

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

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

Check that your SQL query is correct and that you have not misspelled any of the field names in your statement -- along with that the field name exists.

#5 : 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.

This is a record set error. What this means is that you have tried to read into a variable or display in a web page 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 has no data.

You need to first check that there is a record in the set bofre reading it in -- for example : 'If NOT rsRecordSet.EOF Then'


Conclusion

Hopefully you never run into the above listed errors, but if you do you have the comfort of knowing that we have experienced these errors before and can assist you with the issue. If you have any questions please contact our technical support group for further assistance.
(864 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).