What I have is users who request reports, at the moment the reports run multiple queries that take some time to run, which lockes their workstation. What I would like them to do is start an ActiveX exe, on a server, to run asynchronously which will create and save the reports then notify the user via e-mail that they are ready for collection. This allows the user to get on with his/her business and even log off the workstation/go home etc.
I have created an activeX exe that does the business and it works well if it runs on the client machine (not what I want).
I cannot get my head round the method to install it on the server and then let the client machines know it is available.
Using VB6sp5, NT4, TCP/IP network
OK, I know(??) there must be some document somewhere that will tell me how to do this but....