Check faq #8125 Optimizing the VFP Bufffer Size.

>Hi. Recently I have noticed some code in the framework I use that limits the memory as: =SYS(3050,1,2048000). My app is running on VFP7. My app contains two dbc's with a total of 142 tables and 81 views.
>
>I have been experiencing strange errors most recently in my app at different client sites. Most of the clients experiencing problems are running W2K Pro or Win 98. The errors are typically
>error # 23 - Index Expression Exceeds Maximum length
>error # 108 Table in Use by Another User
>
>These problems are seeming to crop up once the user has a certain amount of data in the system. I am thinking these problems could be related to memory and will get worse as the table size grows. Is that possible? I have considered limiting the memory by dynamically setting values upon the start of the program based on the computer's available memory, but I am concerned that I could make matters worse, particularly if the user opens more apps while running my app. The app is an accounting app so the users might be in it all day.
>
>I would appreciate everyone's comments and feedback,
>
>Thanks in advance,
>
>Sandi Cassidy.