I switched to a framework a few years ago and most (if not all) my multiuser programs run just fine. I have one with 50 users pounding 12 hours daily. They only reindex once a month. Data is about 6 gigs now. I'm not sure if it's just dumb luck or the framework (codemine). But I can say it works. I use to have a lot of trouble with memo tables and have just stop using them unless it is impossible to avoid.

I'm hoping to slowly move to either postgres or MySQL. The real reason is not to support more users or to get stability - but to start working with Linux. I'm hoping that Postgres or MySQL will be the engine to support all my future programming and web projects.

My biggest complaint about VFP has been the lack of security on the tables. Several of my users discovered that word and excel could get to the tables (normally I would have thought this was a good thing) and did not use release the connections correctly. This caused me major grief in many ways.

John