Hi Sergey,

I have since found out that Macro substitution in a stored procedure is causing this error message. Some of the stored procedures that validate the record are saving the current ON ERROR routine and then resetting it back at the end of the procedure using ON ERROR &lcOldError. Do you know of any way to restore the error handler without using Macro Substitution?

Thanks,
Pat Moran




>It works for me. Anyway, try to change cursor location to the client side.

oRs.CursorLocation = adUseClient

>
>>Hi Sergey,
>>
>>thanks for the reply. When I click on the links to either the thread# or the message#, I get an error on the page and IE does not display the page.
>>
>>Any idea why I can't use the links to get to the message?
>>
>>
>>
>>>See Re: Strange error using ADO Thread #732052 Message #732062
>>>