I have inherited an Access based program which is a mess. The primary database contains links to at least 7 other mdb files using direct paths i.e. n:\ucs\data\*.mdb. There are over 400 different tables between all of the db's; as well as forms, queries, reports, and macros that number in the multiple hundreds as well. The program is used heavily by around 75 people a day, 25 at any given time. The database in general has a very poor design and has been a work in progress which has been patched and added to more times than worlds largest quilt. Needless to say it is becoming more and more unreliable every day.

The decision has been made to upgrade the Access database to use SQL Server. I believe that a new database needs to be created and the old data imported in so as to not lose any data while improving performance. I also believe that the program itself should be rewritten using VFP as a front-end. I realize this would be a big job but I think it is the right way to do it. The powers that be think that we should upgrade one table or section at a time and continue to use Access databases for the front-end and simply link to the SQL server.

Correct me if I'm wrong but client-server programming is a different paradigm than that of fileserver programming which requires a completely different kind of thinking. What I need is arguments either way. This program will probably be distributed to other locations so I am also looking for portability in this product.

Your ideas will be very much appreciated.
Kris H.