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