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.
Printable View
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.
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.