[RESOLVED] ODBC Connection error opening RS

[FishGuy]

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.

[FishGuy]

More info...
Its not the Index thats causing the problem. Previously when it worked there was an identity column PK_ID. When I deleted this column due to it not been required the above code started erroring.