Picture1
Return records = Yes
Works perfect.
Picture2
Return records = No
Gives an error : -2147467259 Object invalid or no longer set.
rsONDREG.Open "qry_spDeleteTable_sql", cnThisConnect, adOpenKeyset, adLockOptimistic, adCmdTableDirect
When I do the execution like this :
On Error Resume Next
rsONDREG.Open "qry_spDeleteTable_sql", cnThisConnect, adOpenKeyset, adLockOptimistic, adCmdTableDirect
On Error GoTo Proc_err
then everything works well.
What strikes me is that in Picture1 "execute" is blue and in Picture2 "execute" is black.