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

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

> 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