you may want to check if the logged in user have full permmtions to the tableX.
HTH
>Hi there,
>
>Recently, I thought I was having a problem with VFP 6.0 connecting to SQL server 6.5, but it ends up that SQL Server 6.5 was the problem and I hope someone have some answers for me.
>
>I ran the SQL Enterprise manager and select tableX from a database. I know I have only three records in tablex but with following select statement 'Select * from Tablex' and I could not insert,update,delete or select records the table ( The animated global spun forever and eventually SQL Server Enterpise manager hung. )
>
>Thanks in Advance.
>
>Note: Other databases and tables are fine, except 'TableX'
Chen Nan