My views [political or otherwise] are rarely that simple. < bg >
>Or modify the views in View Designer, then go to menu\Query\Advanced Options and check Share Connection.
>
>
>
>>Sounds like your connection in your remote views is no longer shared. Here is some code to run to make sure this property is set:
>>lnRetVal = adbobjects(laViews, 'View')
>>for i = 1 to lnRetVal
>> if upper(dbgetprop(laViews[i], 'view', 'connectname')) = 'CONNECTION_NAME_HERE'
>> DBSetProp(laViews[i], 'View', 'ShareConnection', .T.)
>> endif
>>endfor
>>
Mark McCasland
Midlothian, TX USA