Hello Edward,

>What you could do is to change DataSource property for Connection itself, i.e. it would be the same connection name but pointing to other data.

Good idea, but not possible in this case, since the connections are used by other apps. also. Looks like I may have to recreate the views from scratch.

Regards,
Alan