>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!
I've setup a function that traverses the forms data environment and changes the .Database property to point to the correct set of data. I call this function in the BeforeOpenTables method of the data environment.
HTH
Caroline