I am trying to learn the basics i went through the tutorial on building aguest book here on this site.Everything worked great but when i tried to write a basic simple script to delete data from a very basic Table in my access database it contains two fields item and id# to be exact CrystalId and Crystal the CrystalId Field is autonumbered everytime a crystal is entered. Now the problem
ADODB.Recordset error '800a0cc1'Item cannot be found in the collection corresponding to the requested name or ordinal. /delete_select.asp, line 34
Line 34 looks like this :
Response
.Write ("<a href=""delete_entry.asp?ID=" & rsCrystal("ID_no") & """>")
I have tried everything if i comment that one line out it displays the data just fine But doesnt delete anything i am just learning and this one has got me stumped any help would be most appreciated