>>So the question is: is there a way to alter the connectname for a remote view without deleting and recreating it? (we have a good number of remote views). We would also like to avoid just changing the database in the ODBC source (by going to ODBC admin) since there is the chance of forgetting to change it back as we switch environments.<<
Actually Bob Lucas's approach looks good. But another idea would be to
a) open "Your.dbc" just like you would a DBF
b) Look for the objecttype="Connection" and then change Objectname to the desired connection name.
OK -- I have never tried this, but unless the properties field carries a reference to the connection name, it should work fine (please back up your DBC before trying).
Kevin