Hi David,

I have the same issue as Leeroy and I was wondering if you can expand your suggestion with some more sample code. For some reason (I'm too stupid comes to mind) I "don't get it".

Regards,

Mike


>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?