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.