>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao