> 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. I've solved the question "so when do you need it?" by re-creating the database with the views when it's older than the .exe, or it doesn't exist. Doesn't hurt, since it contains views only. Plus, being on each user's temp drive, it has no chance of having any network issues.