p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: Re: Microsoft JET Database Engine (0x80040E09)


Message #1 by "Imar Spaanjaars" <Imar@S...> on Thu, 13 Jun 2002 20:47:14
Just checking..... Is your database read-only on disk level?

Sometimes (when you email it for example with MS Outlook) the read-only 
attribute gets set.

Imar


> Having a bear of a time figuring this one out:

> Error Type:
M> icrosoft JET Database Engine (0x80040E09)
C> annot update. Database or object is read-only.

> I found other threads addressing this, but no luck applying the 
suggested 
r> esolutions.

> Code is as follows:

> <%
	> dim objRS, intRecordID
	> 
	> set objRS=server.createobject("adodb.recordset")
	> objRS.Open "Viruses", strConnect, adOpenForwardOnly, 
a> dLockOptimistic, adCmdTable
	> inRecordID = request.Form("virusitem")
	> 
	> objRS("Virus_Item") = intRecordID
	> objRS("Title") = request.Form("title")
	> objRS.Update
	> objRS.Close
	> set objRS = nothing

> 	set objComm = nothing
%> >

> folder in which the .mdb is located has write permissions, and the 
Access 
D> B has no password and an Admin and Users User with full permissions.

> Any help would be appreciated.  Thanks in advance

> Gary Schultz
Message #2 by "Gary Schultz" <gschultz@n...> on Thu, 13 Jun 2002 20:44:03
Having a bear of a time figuring this one out:

Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.

I found other threads addressing this, but no luck applying the suggested 
resolutions.

Code is as follows:

<%
	dim objRS, intRecordID
	
	set objRS=server.createobject("adodb.recordset")
	objRS.Open "Viruses", strConnect, adOpenForwardOnly, 
adLockOptimistic, adCmdTable
	inRecordID = request.Form("virusitem")
	
	objRS("Virus_Item") = intRecordID
	objRS("Title") = request.Form("title")
	objRS.Update
	objRS.Close
	set objRS = nothing

	set objComm = nothing
%>

folder in which the .mdb is located has write permissions, and the Access 
DB has no password and an Admin and Users User with full permissions.

Any help would be appreciated.  Thanks in advance

Gary Schultz
Message #3 by "Gary Schultz" <gschultz@n...> on Thu, 13 Jun 2002 20:52:48
> Just checking..... Is your database read-only on disk level?

> Sometimes (when you email it for example with MS Outlook) the read-only 
a> ttribute gets set.

> Imar

Yep, already checked that, right-click, properties, read only is NOT 
checked

  Return to Index