>Thanks Craig.
>
>>Stupid programmers are developers that don't do the right stuff in their programs to eliminate these problems. Somethings that can be done are use views, buffering, FLUSH, etc.
>
>I use local view throughout my app. Do I need to use FLUSH even when I use views?

Yup.

>
>Can you tell me what is MSDE?

Microsoft Data Engine. Essentially, it is a desktop version of SQL Server. It is optimized for 10 users and the database is limited to 2 Gig total size. It will ship inside the box with VFP7.