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?