Solved

Terminal Server running Access App problem

Posted on 2000-04-04
6
243 Views
Last Modified: 2013-12-28
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?

Any ideas?

Thanks
0
Comment
Question by:jkan052699
6 Comments
 
LVL 9

Accepted Solution

by:
dlb6597 earned 400 total points
ID: 2684255
Was Terminal Server in "install mode" when access was installed?

Also, you can get NTFILEMON and NTREGMON from http://www.sysinternals.com to show access problems to files and registry keys without applying auditing to all files.
0
 

Author Comment

by:jkan052699
ID: 2684281
Yes Office was installed per MS instructions.

Have tried Regmon already. Useful but it hasn't helped me track down the keys that cannot be accessed.
0
 
LVL 4

Expert Comment

by:wlaarhov
ID: 2687600
Look in the profile of the user that has installed the software.
Just this afternoon I had about the same problem with another application.
It turned out that some of the files and some ini files landed in the c:\wtsrv\profiles\administrator\windows directory.
The solution was to use the control panel / system applet / User profiles tab to copy the administrators profile to "default user".
After deleting all existing profiles and letting users logon again my problem was fixed.

0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 1

Expert Comment

by:chhogan
ID: 2695199
Go to c:\wtsrv\systems32\msjet35.dll and make sure permissions are set to read access for everyone and see if that fixes the problem.
0
 

Author Comment

by:jkan052699
ID: 2699794
Thank you all.
I have got a response from Microsoft and it seems that Office was not originally installed in install mode. The downside of this is that we have to reinstall Terminal server from scratch as uninstalling office then using eraser97 then reinstalling office in install mode does not seem to work.
Good eh.
0
 

Author Comment

by:jkan052699
ID: 2699816
To chhogan
Thanks for your help.
Sorry but I had to reject your answer as I wanted to give the points to dlb6957 as his answer was the closest to the one offered by Microsoft.
The msjet35.dll was one thing that I had already covered during the file audit.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question