>Chad,
>
>Both .NET Data Access and VFP use SP_ExecuteSQL to do their work with SQL Server. Check the profiler and you'll see this.
Ken,
That is true, but that is more internal than what you described you were trying to do. If all you want to do is to limit access to the table except from within your app, you could create a SQL Authentication account that your application uses to connect and then don't add any Windows authentication access for user 'Bob'. Would something like that not work for you?
Chad
_________________________________
There are 2 types of people in the world: