George,
First, I have had tables near the 2gig mark with NO inherent slowdown.
However, I do remember, probably 2+ years ago now, Barbara Paltiel having random problems including things like "no index set' and several other oddities and the fact that this happens more in the afternoons makes it worth mentioning.
In her case, if memory serves, it was all found to be related to a printer server and load thereon. As I remember their solution, printing was relocated and the problems went away.
good luck
>Paul -
>
>This could be happening. The errors seem to have local views involved. Do you know which page/chapter/book this was in? I'm looking at:
>
>The Fundamentals: Building Visual Studio Applications on a Visual Foxpro 6.0 Foundation
>
>
>by Wil Hentzen.
>
>Is this the book you're referring to?
>
>- George
>
>>By any chance do you have views defined in your DBC and all users have access to the
same DBC? If so, I recall reading one of the Hentzenwerke books--I don't remember which one--that all views should be stored in a local DBC. There seems to be an issue that VFP will lock the view for a short time; hence, user conflict with two or more user opening a the same view at the same time.
>>
>>This one problem maybe the cause of all your other errors that you are getting.
>>
>>HTH,
>>
>>--Paul