That's an old problem :) It's solved 10 days ago :)
Can you believe my bad luck? I forgot to turn on PCAnywhere at my work machine and now I have to write SP in the notepad...
>Hi Nadya,
>
>From a newbie point of view, I am wondering where you define objConnection... and if your ADO is already set on a connection, would
>
>
objRS.Open strSQL, , adOpenForwardOnly, adLockReadOnly, adCmdTableDirect
>
>work instead?
>
If it's not broken, fix it until it is.
My Blog