Thanks Josh,

I am only starting with SQL and there is so much.

I am going to set the cursorsetprop as you recommend !

Many Many Thanks

Xavier

>Xavier,
>
>ODBC only allows one command to execute at a time over a single connection. If you're using views and you have the FetchSize for the view set to anything other than -1 you can get into a situation where one view is not done requerying when you try to requery or update another view. The easiest thing to do is to just set the FetchSize for each view to -1.
>
>>Hi there,
>>
>>I am using ODBC to SQL Server to update a few tables. When i run my update prog. I get this error message after a while connection ... is busy. What does it mean and how can I avoid that.
>>
>>Many thanks
>>
>>Xavier