>I have an application that runs on a server, but also runs locally on a lot of notebooks.
>
>When there are changes to the system tables/views/structures etc. they are first made on the server and then transferred to the notebooks.
>
>At the moment I am copying over the database(DBC,DCT,DCX) files when anything is changed.
>
>But when structures of tables are changed I issue a program that does this.
>
>I am now experience the problem that the DATABASE files are note matching the tables. Should I be transferring the changes differently, or should I be ok just copying over the DATABASE files?
>
You need to make the changes programmatically; I'd strongly recommend using a commercial product, Stonefield Database Toolkit, which handles this task very well by maintianing separate metadata tables describing table and database content details, and providing a set of classes to update a current database's structures to match the metadata.
www.stonefield.com