Hi folks!
I have created a simple set of ASP pages with ASPRunner to add, edit and modify a simple Access DB which works fine when I test it on my XP PC running Internet Information Services on it. However, when I upload to Brinkster.com I get the following error when I try to add, delete or modify a record:
----
ADODB.Fields error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/mrbobuk/personal_info_tableedit.asp, line 301
----
I can't understand what the problem is as I am a newbie to ASP. Anyone with any ideas? I've scoured the Usenet and tech articles but what they state as a resolution to this problem is beyond me. Please help!
I've pasted my ASPRunner code in below that is pertinent to the error:
----
for i=0 to rs.Fields.Count-1
for j=0 to i-1
if rs.Fields.Item(i).Name=rs.Fields.Item(j).Name then
i=i+1
j=i+1
end if
next
sFieldName = rs.Fields.Item(i).Name
bSkip = false
if sFieldName = strKeyField and not bKeyFieldEditable1 then
bSkip = true
if sFieldName = strKeyField2 and not bKeyFieldEditable2 then
bSkip = true
if sFieldName = strKeyField3 and not bKeyFieldEditable3 then
bSkip = true
----
HELP!
Robbo <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=246&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
