>Currently, our users, via their Windows logon privileges, are given access to the various network drives containing data files needed by the VFP applications they will be using. The potential, unfortunate side effect of this, is that a malicious, capable user could use a tool like Excel to attempt to open & view the raw data files.
>
>Is there any way we can use SQLCONNECT or other commands to prevent such access? What would be ideal, is if the user's Windows logon didn't provide any network drive access; rather, the compiled applications would connect the appropriate connection strings & passwords to provide access from within the application only.
>
>Can this be done with VFP, & if so, how?
>
>Thanks very much,
>Randy
You can use impersonation to access tables in protected directories, you can see Message #
948574 for a simple sample. In the same thread, Anatoly points to a Wiki where he discuss this further.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges