I am working on a project consisting of VB ActiveX DLL'S, SQL SERVER Database, and VB frontend. Now what I have done is created the ActiveX dll and am trying to export that dll to multiple client machines which have to run the VB frontend using a reference to that one particular dll. My database and activex component are on one system and I have 15 clients. I am trying to use MTS. I have created a package in MTS and Exported it to all the clients and at the client side I have referenced the dll that exported through MTS. But when I run the VB front end at the client side I get an error "Permission Denied". I have not set up any permissions on the SQL Server database nor on the MTS package that I created. I am unable to understand that error and now I am stuck on that for almost a week now.

I wouls really appreciate all the help.

Thanks