Many of you had been concerned with the Database property which is read-only at design time... the end result of this is that people with two copies of their dataset (one for development and one for production), even across a network, will have the app look at the original development copy of the dataset..bad indeed!
The best solution I could come up with is the hardcode the following into the BeforeOpenTables() event of the DE of each form:
this.Cursor1.Database = "..\Data\Main.dbc"
this.Cursor2.Database = "..\Data\Main.dbc"
... etc.
This seems to work very well, even if you move your distribution directory!