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