>I am connecting to an Access database through ODBC. I have remote views setup inside a standard VFP database.
>
>My question is, is there a way to change the connect name on the fly. There doesn't appear to be a way to to this as the name is stored in the DBC and the 'ConnectName' option within dbsetprop() is a read-only property.
>
>Many thanks.

This is one of the limitations of remote views. In order to specify different sources, you need to use SQL Pass-thru specifying a different DSN (or connection string) each time.