>I am working on a project to rewrite a VFP app into ASP.NET with SQL 2000. The VFP app has been around for a long time. (It should have been rewritten years ago). The problem we are having is with tables that are still in Fox 2.x format. We wrote a script to add the tables not belonging to a DBC to a DBC so that we can upsize to SQL and then use DTS packages to populate the new database structure. The problem is that we are prompted to update the structure of the table before we can continue.
>
>Is there anyway to suppress this dialog? Just by default update the structure are needed.
You can copy them in VFP using COPY TO command which will convert them into VFP format. After that you can add them to DBC w/o prompt.
--sb--