Josh alread pretty much summed it up (well in general terms anyway <s>) I only want to add one more consideration in your re-design which is if you want to go with a 2-tier C/S architecture or a n-Tier if you are going for n-tier you also have to consider on where you want each action to be taken (which tier) (we have here Forms, form behaviours and naturally the database, and the work is split between the 3) Arnon > >We are using a database that has 700,000 customers and about 1 M+ of orders; we've been told that a client/server structure is more robust, safe and able to communicate with other technologies such as IVR's and the like. Currently we have all the data in a server computer and this is accessed through apps installed in the workstations, which just makes it a file sharing system. What does it take to do the migration to client/server and how complex does it get?. Any FAQ out there? > >Thanks a MILLION for the help > >Gil