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

Asked By vipul jain on 25-Oct-08 03:16 PM
I am getting this error when i am login in my login page in local host i get the login page but cant move forward as i get this error

Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/login/io.asp, line 25

i have given all the permissions but still the same

can anyone help me

Database or object is read-only. - Binny ch replied to vipul jain on 25-Oct-08 11:31 PM

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

Microsoft OLE DB Provider for ODBC Drivers (0x80004005) - Binny ch replied to vipul jain on 25-Oct-08 11:32 PM

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.

solution - Perry replied to vipul jain on 26-Oct-08 12:06 AM

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
solution - Perry replied to vipul jain on 26-Oct-08 12:06 AM
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
re - Web Star replied to vipul jain on 27-Oct-08 01:20 AM
If you are developing with MS Access, you've almost certainly seen this error message before: 
 
Microsoft OLE DB Provider for ODBC Drivers error '80040e09' 
or 
Microsoft JET Database Engine error '80040e09'
 
There are many different error messages that can go along with this. 
 
Record(s) cannot be read; no read permission on '<table name>'. 
 
or 
 
Cannot update. Database or object is read-only.
 
Make sure IUSR has access to the database (for more information, see http://www.aspfaq.com/show.asp?id=2062). 
 
With SQL Server, the error message might be a little bit different: 
 
[Microsoft][ODBC SQL Server Driver][SQL Server] 
EXECUTE permission denied on object '<proc name>', database '<database name>', owner '<owner name>'.
 
...but again, make sure the user you're connecting as has appropriate access to the table, stored procedure or any other object you are attempting to access. 
 
Another possible problem could be trying to issue an Update or Resync command on an ADODB.Recordset object based on a SQL Server view: 
 
[Microsoft][ODBC SQL Server Driver][SQL Server] 
SELECT permission denied on object '<table name>', database '<database name>', owner '<owner name>'.
 
See http://support.microsoft.com/default.aspx/kb/253673 for information on resolving this issue. 
 
Some databases will toss this error if you put quoted identifiers around table or column names, e.g.  
 
SELECT column FROM table WHERE 'column_name'=1
 
Quotes are for string literals, not object names. 
 
With MySQL, this error can come up if you have a malformed SQL statement. 
 
Microsoft OLE DB Provider for ODBC Drivers error '80040e09' 
[TCX][MyODBC]You have an error in your SQL syntax near '<something>' at line 1
 
Can't offer much here, except to debug your SQL statement (see http://www.aspfaq.com/show.asp?id=2145) and make sure its format is correct.
Folder Rights to IIS user - Prem Dhanendran replied to Web Star on 02-Feb-09 05:22 PM

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

Rem replied to vipul jain on 22-Aug-10 06:13 PM
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.