Thanks, Fabian. Figured this one by myself, but it cost me almost 2 hours...
Too bad, you were not online earlier :)
>Nadya:
>
>
>objRS.Open strSQL, objConnection, adOpenForwardOnly, adLockReadOnly, adCmdTableDirect
>
>
>Change above line to
>
>
>objRS.Open strSQL, objConnection, adOpenForwardOnly, adLockReadOnly, adCmdText
>
>
>HTH
>
>Suggestion: IMHO, lock syntax here isn't necessary, SQL manages locks on it's own fine.
>
If it's not broken, fix it until it is.
My Blog