>If you need to change table structures without losing existing data, check the Stonefield Data Toolkit. SDT is designed for JUST this purpose. You can include it in your EXE or make a separate maintenance EXE.
>

I am looking at the dbgetprop() for checking the database version. It is always returning a value of 10, even after i've added tables, deleted table or whatever. Where is this db version coming from? Is there any control over it's value?

If it's controlable then i'd be able to check the version # and write code to do whatever is necessary to keep the tables in sync.

I'll check out the SDT. Hopefully there's a demo version.

kim