Matthew ---
The best way is to write a script and compile it to an EXE; send that and new tables/CDXs...script might contain.....
**** For new tables
OPEN DATABASE mydata
ADD TABLE newtable
**** For new views
CREATE VIEW newview AS SELECT..... (etc)
**** For structural changes to tables
ALTER TABLE mytable ALTER COLUMN .... (Or)
ALTER TABLE mytable DROP COLUMN ....
>Once my application is installed and running at a customer site, what is the best way to handle changes to the .dbc?
>
>1. Adding new tables or views
>
>2. Modifying/adding/deleting fields in a table or view
>
>Thanks in advance for all thoughts and suggestions.
>
>Mat
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05