Ikky,

I don't think it is the database to blame here because I redesigned it adding renamed "ID" to "ButtonID" and adding a "RecordID" column! The data is saved in the database correctly and this is the code I use to save the ids

Code:
          rs.Fields("ButtonID") = Main.Command1(cmdindex).index
          rs.Fields("RecordID") = Main.Command1(cmdindex).index
now given that all the information is being pulled from the database there should NOT be a problem with

Code:
 rs.MoveNext
However, I still encounter the same error as above.