Leeroy,

If you keep all the files in the same relative locations, you can simply OPEN the DBC and SET DATABASE to the one that you want at the beginning of the program and it'll use the correct data.

.\data
   \test1
      thedatabase.dbc
      table1.dbf
      table2.dbf
   \test2
      thedatabase.dbc
      table1.dbf
      table2.dbf
   \production
      thedatabase.dbc
      table1.dbf
      table2.dbf

You don't have to change any paths.

>If I was to use the dataenvironment of a form to open tables, my problem is that we have several copies of our database. It seems that the path to the database is stored with-in the dataenviorment of the database used at design time. However, I do not want to use that path at runtime.
>
>How then, do I change the database path contained with in the dataenviornment of a form at runtime?