ASP - Cannot update. Database or object is read-only.

I believe you will need to check your lock type on the recordset object. If you do not set it, my recollection is that the default is adLockReadOnly.

Prior to the open set the locktype to adlockpessimistic or whatever you believe is appropriate.

Give it a try

This error usually indicates that you did not set the appropriate permissions on the database, "somename.mdb". The security account used by the web server IIS service should have at least "Write" permissions on the database file (Note: You cannot set the permissions from within IIS, see below).

HOSTED SITES: Most web hosting services have a 'file manager' or permissions manager available for you, usually in your control panel - contact your web host for assistance. If your host does not offer a permission manager, they will be able to adjust the permissions for you.

DEDICATED SERVERS: To adjust the file permissions, you need to locate the file "somename.mdb" by using "My computer". Right click on the file, click on "Properties". Next, click on "Security". There are several user/system accounts listed, you'll need to modify the permissions for the account that the IIS web service uses (if you don't know, you can always add the user "Everyone" and give it "Full Control").

IIS CONSOLE: You cannot use the IIS console to change the file permissions, the Access settings in the IIS console are not the same as "File Permissions". The settings in IIS only control what web browsers/internet users have access to (not file security).

MISSING SECURITY TAB?
If your hard drive is formatted NTFS, you can set permissions on files and folders by right-clicking on the file. If your XP workstation is a standalone or part of a workgroup, the security tab may be hidden. To unhide, open Windows Explorer. Choose Folder Options from the Tools menu. On the View tab, scroll to the bottom of the Advanced Settings. Clear the check box next to "Use Simple File Sharing." Click OK to apply the change.

loadTOCNode(1, 'cause');loadTOCNode(1, 'resolutiThis may also occured if file is currently used by another program or user or The file that you are importing or that you are trying to export does not have a recognized file name extension. To resolve this Rename the file name extension so that it matches one of extensions listed in the "More Information" section later in this article. -or-  Modify the following registry key to include the extension of the file that you are importing.

HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions

You can find workaround/solution to this problem at http://www.pagedowntech.com/faq/faq.asp?faqid=18  and http://support.microsoft.com/kb/245407

Regards,
Megha

This may also occured if file is currently used by another program or user or The file that you are importing or that you are trying to export does not have a recognized file name extension. To resolve this Rename the file name extension so that it matches one of extensions listed in the "More Information" section later in this article. -or-  Modify the following registry key to include the extension of the file that you are importing.

HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions

You can find workaround/solution to this problem at http://www.pagedowntech.com/faq/faq.asp?faqid=18  and http://support.microsoft.com/kb/245407

Regards,
Megha

Check if the IIS user on AD has rights to the Database folder and also to the related entities for login inside the DB.

Prem Dhanendran

I had the same error poping up... It was a simple mistake in my code. I had selected distinct items from the database. If you select * (all) it can fix that problem.