p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: Microsoft JET Database Engine (0x80040E21)


Message #1 by "Gary Schultz" <gschultz@n...> on Thu, 13 Jun 2002 22:33:02
Resolved my previous issue with regard to "object is read-only" when 
attempting to insert into an access database.  By disabling simple file 
sharing in windows XP i was able to properly set permissions to the 
folder in which the .mdb file was located.  However now I get the 
following error:

Microsoft JET Database Engine (0x80040E21)
Field cannot be updated.

Source code is as follows:

<%
	dim objRS, intRecordID
	
	set objRS=server.createobject("adodb.recordset")
	objRS.Open "Viruses", strConnect, adOpenStatic, 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
%>

suggestions?

thanks in advance.

Gary Schultz

  Return to Index