>> If you decide to redefine the entire view on the fly, you might want to check out EView here in the files section- it will generate code from your view that can be used to recreate the view. You could even modify that code to take a parameter for the connection to use. Be aware that redefining a view on a regular basis will contribute to DBC bloat.
>
>Not necessarily, if you create the .dbc when you need it, and keep it on the temp drive.

Well, it still contributes to DBC bloat. How much a problem you perceive this to be is another question. Obviously if your dbc is created and destroyed fairly often, you have nothing to worry about.