>Hi, I have a problem on inserting on one of my tables. There are times that I cannot insert records on a specific table. It seems that the table in frozen. Im using remote views to do the inserting. But no matter how I tried, it simply won't work. I have to figure it out until I got to a point when I have to browse my dbf table. I tried inserting a new record in browse mode by pressing ctrl + y then I tried to run the inserting code again and it worked. This problem occurs frequently and what I do is do an insert in browse mode and delete it then run the program again and it works. How come this happen, I simply lost my focus coz I can't find the solution.
>Please help....
>
>Thanks in advance


Try resetting the WhereType property of the remote view from 3 to 1. This is another one of those corruptions an RV can get that Microsoft cannot fix or explain.

HTH

-Justin