>
>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.
>

Kris:

I think you need to look at the business decisions behind this move. The 'powers' don't want to interfere with the day_to_day processing that is performed on the system. While I personally think the thing sounds like it needs to be rewritten from scratch, the company may not be able to afford that kind of operation or may not want to.

This may be a two-phase upgrade... you might have to migrate the data to SQL server as-is - to avoid the limitations of Access. Then work on the rewrite with SQL and VFP.