Hi Mark,

BOb Archer supplied the answer. Apparently this is a design change in VFP9. You can get a sharable connection using the syntax

ConnString = 'dsn=YourDataBase;uid=YourUserID;pwd=YourPassWord;QueryLogFile=No'
nHnd = SQLSTRINGCONNECT(ConnString,.T.)

but to actually open multiple views you need to get a second handle from the first one as

nHnd2 = SQLCONNECT(nHnd)

With nHnd2 you can open multiple views with no problem.

Regards,