>Do you mean by registering the COM object with DCOM and remoting the object or are you saying you can run a COM object with user rights other than the current process?. If the later, how do you do that?
Run the COM object remotly, preferably in MTS. You assign the package to run under a particular user id. It's this user id that will have rights to the data...not the user.
>
>Guy
>
>>>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer