>>We use a number of views and SQLPT and need to share the connection, I dont think there is any way to do that if we open the view using a connection string.
>>
>>Thanks
>
>Mike,
>The CONNSTRING clause can contain a character string with the necessary connection information or it can contain a numeric value designating the connection handle to use. This is available i VFP 8 and is documented in the Enhanced Classes, Commands, and Functions section.
>
>HTH.

Thanks for that information Larry, I wasn't aware of that change and it isn't documented in the help on the USE command. We will adopt that approach when we move to version 8.0 but we will probabably need to use our current workaround of a FileDSN for version 7.