Thanks Fred

I've already tried something similar and it isn't working.

I have a "pathselect" form from which a dataset is selected.

I then close any open databases, and open specifically the dbc in the selected target path. Although this succeeds and manual "use" commands open the correct tables, the problem seems to be the tables used in the dataenvironments. These seem to insist on using only the tables in the location I pointed do during development.

suggestions?


>There are a number of different options depending on how you have coded the app but this is the way I would handle it. You can store each business in it's own data directory and use the same DBC name and table names.
>
>You could have a naming convention for your data folders or a configuration file pointing to the data folder. This way you could add as many businesses or datasets as you wanted. When opening the DBC, just be sure to get the selected one.
>
>
>
> Business 1
> \\Server1\Share1\Data
>
>
> Business 2
> \\Server2\Share1\Data
>
>
>
>Hope This Helps
>
>
>
>>I have a client who uses both my DOS and VFP6 applications which do not make use of DBC technology.
>>
>>I've upgraded to vfp8 and decided its time to use the enhanced transaction security and various other things that come with DBCs.
>>
>>My client runs two separate but very similar businesses using my software and all they have to do on entry is pick the relevant dataset from a popup and all the relevant datafiles are correctly opened as required.
>>
>>How do I achieve that functionality with DBCs?