>Is there a way to change from one copy of a dbc to another. I have a database in my project with tables, local views and stored procedures. I want to setup three copies of the database one for development, one for testing, and one when it is deployed to production. I would also like to store the database on a server and the code on the local machine. Is there an easy way to 'switch' the various databases when the main program starts or by setting a path? I think I can do it using VFP ODBC driver and remote views, but is this the only and best way? I'm using VFP 7.0
>Thanks!

We keep a development and production environment on the network or local PC. With the use on an INI file we can set a value called SystemType=PRODUCTION Then the program would look for the data locations stored in the INI file ProductionDataPath=\\402fs1\data\ or if this was a local machine test ProductionDataPath=c:\data\ but if the SystemType=DEVELOPMENT then the program would look for the INI entry DevelopmentDataPath

So it is with one executable, but two different data sets. The users (mostly developers) would change the INI entry to which ever they wanted before the program started.