Try login is as 'pomuser' in SQL Server Query Analyzer and try to do the same thing as you are trying in VFP.
My guess is that you will find the same behavior on both sides. If it does, then the problem is the security settings for the user.
>Thank you! Everything works fine.
>But I got another problem with SQL-Server permissions.
>
>My SQL-Server table (pom_punches) has permissions setted like below:
>-User name is 'pomuser' and only the Insert permission is granted.
>When I do connection to my SQL table in VFP
>(using SqlStringConnect function with UID='pomuser';PWD='xxxx'),
>the result is success (I get an handle). But I can also do a
>SQLEXEC(lnhandle, "select * from pom_punches", "mycursor")
>or a SQLEXEC(lnhandle, "delete from pom_punches") with success.
>Why the Select always works (permission is revoked)?
>
>Thank you again for your help.
Hector Correa