I get an error on this line
rs.Open strSQL, cnn, adOpenDynamic, adLockOptimistic, adCmdText

It used to work fine until I made the only two columns in the table it references an Index.

Would anyone happen to know why this would cause a problem.