PMFJI, but THANKS, Craig, for the tip on granting access rights to a COM object through a unique user profile. I'm starting a new project next week that will use this! And, uh, BTW, it had tripped me up in earlier COM projects, too!
All together now: Duuhhhh.... <bg>
>>Hi,
>>Craig.
>>
>>By com components if trying to connect to nt server will have rights to the user.
>>similarly he will have the rights to access to that database by foxpro or visual foxpro also, thus has the overall rights to play with the database.
>
>The COM object will run under a different user profile, hence you can stop people from getting to the data. It's easy to do. The user is never given rights to the data, only the user profile for the COM server.
"Problems cannot be solved at the same level of awareness that created them." - Albert Einstein
Bruce Allen
NTX Data