We have a Terminal Server setup in our domain which recently had an Access 97 app installed. Only the Domain Administrator account can run the app properly. Members of Domain Admins and even the Local Terminal server administrator account cannot execute the .mdb properly.
The application itself is attempting to launch a new instance of MS Word 97 and Access returns error code 70 - Permission denied. Access is using OLE automation to launch Word. Below is the code that fails:
Dim objWrd As New Word.Application
objWrd.Visible = True
............. results in the error above as soon as Access attempts to create the object application.
We can see Word running as a process in Windows NT. We have attempted every method possible to launch Word without success, including using the CreateObject() method, etc ... Application level permissions are correct.
I set auditing on all files and found that the program was failing to access certain files due to NTFS permissions. I have resolved this but the app still doesn't function correctly. I have tried to audit the registry but failed with Terminal server saying that I am tampering with the license agreement or something. Is there a way around this?