Sorry about those 2 h. ($40 x 2 = $80)!
;)
>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.
>>