Hi Kevin,
I use an INI file and just change it when I want to point at different data locations, but if you don't like doing that, how about keeping a dbf with the various paths and displaying this list when in development and selecting the path?
>I have data located in different places.
>
>There is a production database at the client site, a test database at the client site, a copy of the client's production data on our office network, and another copy local on my PC. In addition, the QA department has their own copy.
>
>There is an entry in the INI file for the data path, but it's a PITA to change the INI file to point to the data I want to test against.
>
>I considered creating a data location picker which would be displayed on startup only in development. I could create entries in the INI such as DataPath1, DataPath2 and so on. DataPath1 would always be the location of the production data.
>
>Then, when the data location picker comes up, I could select the DB I want to run against.
>
>Anyone have any better ideas?