Hi Michael,
>I'm adding a table to the database. I have a stored procedure which opens and relates the tables. I want to update that procedure to open the new table. This operation may be required at 12+ locations, each with the same database structure containing unique data.
>
>Is is possible to make the change on the development copy of the database, and copy the new database (.dbc,.dct,.dcx) files over the old ones at each location? (I am hoping to get some feedback before possibly destroying the installed data and having to start over)
Be
very careful here! From what you've described, you would need to distribute a copy of the new table as well. I personally use a combiniation of .Prgs to update the existing database, checking the version first! And then distribute the final Dbc with new Stored procedures and Views, etc. to accomplish this.
If you can, Stonefield Database Toolkit would be a great help here too. (Arguably, the best)
Bill Armbrecht
VFP MCP