>>ok
>>but i should mention that i have the connection string in a "connection" named Upsize
>>
>>

>>Handle=SQLCONNECT('Upsize','','',.T.)
>>
>>IF SQLExec(m.Handle, 'SELECT * FROM useraccesscon', 'User')
>>  browse
>>   MESSAGEBOX("Success")
>>ELSE
>>	MESSAGEBOX("Failed")
>>   
>>ENDIF
>>

>>
>>Resulting Error / Handle is invalid
>>
>>Handle = SQLSTRINGCONNECT("DSN=dpsal;UID=Josephine;APP=Microsoft Visual FoxPro;WSID=HP6PQ8;DATABASE=RemoteAccess;Network=DBMSLPCN;Address=HP6PQ8\SQLEXPRESS,1433;
>>Trusted_Connection=Yes;Regional=Yes;UseProcForPrepare=0")
>>
>>

>>IF SQLExec(m.Handle, 'SELECT * FROM useraccesscon', 'User')
>>  browse
>>   MESSAGEBOX("Success")
>>ELSE
>>	MESSAGEBOX("Failed")
>>   
>>ENDIF
>>

>>
>>REsulting Error / Data type Mis-match
>>
>>the error points to the following line
>>
>>

>>IF SQLExec(m.Handle, 'SELECT * FROM useraccesscon', 'User')
>>

>
>Did you read my last comment? This line of code is incorrect because SQLExec returns a number, not a logical value.


oh im sorry the last comment didnt get sent to me. I got it now