>Carlos,
>
>Yes, There are two databases and I just tried your suggestion.
>It seems like no matter which way I try to do it; DBSETPROP to change the Connection String, or Open the DataBase depending upon Production or Test, The result is the same:
>
>The Wizard generated form seems to "remember" the database that was selected during the generation process and no matter what I set the connection to or which database I open, the form processes data from the connection/database at generation time.
>
>I need to find out how that can be over-ridden at run time.
>
>Your good ideas got it this far and I thank you for that. Please advise if you have some ideas on this re-definition of the problem.
>
Bob:
Check this out:
How To Assign Database Location Generically in Data Env
http://support.microsoft.com/?scid=kb%3Ben-us%3B128996&x=16&y=11Maybe you could make Data_Drive and Data_Path properties of _Screen. I have never used this method, nor I know if it is the best way to deal with this. I never use two databases like your scenario, just one database with only remote views, and I just change the connection string.
Carlos Alloatti