>We are putting a VFP 6.0 app out in 40 offices around the world with SQL Server 7.0 as the backend. The nature of the beast is; we are still doing development on the app. So we need to send updates out the the offices we have already setup. Updating the codse is no problem. The problem comes in when we change the structure of the SQL tables. Is there anyway to automate the updating of the remote view structures?
>
>Changes can be anything from field size changes to adding and deleteing fields.
>
>Ideas?
>
>Thanx

If all you are doing is changing remote tables, you could try just sending the offices the new DBC, DCX and DCT files since this is where the updated info about those remote views will be located. SDT also handles this for you very well.