cursor was creted with the SQLEXEC. Like I said, local cursor did not have a problem, only remote.

thansk again

>> I just reinstalled MDAC and it worked.
>That seems strange that something outside Fox affects the ALTER TABLE command. Glad you got it working.
>
>Just curious, was your cursor created with SQLEXEC or the CREATE CURSOR command?
>
>Thanks,
>Bo Durban