>Hello,
>
>We are constantly updating our software to our clients through pcANYWHERE. This works fine for the code, but poses big problems if I make any changes to the tables.
>
>What I do now is download their table, modify it on my computer in VFP, and upload it back to them. With large tables, this can be time consuming.
>
>I would like something that I can install on their computer to modify the tables locally. By putting a browse command in the code, I now have the ability to change the data directly, but it doesn't allow me to change the table itself.
>
>I want to be able to do the following things: Add/delete fields, add/delete indexes, and pack the table.
>
>Is there a program that does this already? If not, do you have any ideas on how to go about writing such a thing? The pack command I think I can handle. :) But I have no idea how to modify the structure programatically.
>
>Thanks,

Stonefield offers this (see their ad in the Partnership area of UT). Some of us also include a "command" window simulation in our apps that we can invoke with (usually) an undocumented *on key* combination. We protect/hide it so our users can't access it themselves.