Hi Naomi

It has over 120 fields. But problem was index.


Moises


>>Hi
>>
>>I have a .save method in my form, saving many tables as below.
>>When I try to save the table "ap" VFP locks, waits, and shutdown and I have no error message.
>>
>>******************************************************
>> SELECT AP
>>IF NOT TABLEUPDATE(1, .t., [Ap])
>> AERROR(laError)
>> MessageBox([Can not update AP : ] + laError[1,2])
>>ENDIF
>>******************************************************
>>
>>Can I be a corrupted table ?
>>
>>When I open it with use ap it seems ok.
>>
>>Have anyone ever came across with such a problem ?
>>
>>Moises
>
>What is the primary key for the table? How many rows this table has and how many are updated? Also, have you tried deleting FoxUser?
>And also, did you try using different alias for that table, say, apWork?