>Was brought into a company which has 350 user VFP 6.0 system with roots back in a 2.6 application. The system has scaled way beyond the exisiting system of 60 users. The FoxPro backend crashes 5 times a day with data corruption. The senior management has decided to go to SQL Server 2000 and has hired me and few consultants with enterprise Database experience. The current programming department (one developer) is extremely resistant to changing the architecture from a client\server(1996 vintage) system to a scalable n-tier or 3-tier system. He is in the process of porting over some of the UI screens to point towards remote views which he will locate on the clients local harddrive. I'm not asking for help with interoffice politics but what resources can I point to convince management that this is still a "hack" and will not work on a system with this many users. We are thinking of a n-tier design with SQL server 2000/VFP BusinessRules COM server/VFP Data Access COM server/User Interface. The data will be communicated through the COM layers with either XML or ADO. As some of you know, coming into disassemble someone's kludgeware system can be difficult when the designer of the system is on staff is desperately trying remain relevant yet remain uncooperative.

John --

I'd suggest you take a look at the frameworks that address n-Tier design in VFP. I know that Mere Mortals does, as well as the latest rev of CodeBook -- there may be others, of which I'm not sure. Others can certainly fill you in.

I mention these tools for this reason. You may or may not use one of them. But, the advantages they offer to a developer will be similar to those offered by the architecture you're proposing.

Mere Mortals, written by Kevin McNeish, has a website at http://www.oakleafsd.com. I think Codebook has info at www.Flash.Com but I'm not sure.

Enjoy!

Jay