>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer