Home All Groups Group Topic Archive Search About
Author
12 May 2005 11:11 PM
KLomax
I have built an Windows Service, and I am getting an [Access Denied] error
when I execute the following line.
Dim AcApp As Access.Application = New Access.Application()
The Service is Logged on as a Domain.User.
If I give this user Local Administrator rights, then it works.
However, I do not want to grant this user account administrator rights.
Does anyone know if, or what, security policy might be disallowing a service
to Instantiate MSAccess unless the user is an administrator?

Thanks in advance.
Ken

Author
13 May 2005 12:09 PM
Nicole Calinoiu
I doubt that this is a privilege issue.  It's more likely to be related to
NTFS permissions on required files and/or registry keys.  Running filemon
and regmon (www.sysinternals.com) is likely to be your best bet for
pinpointing any such problems.  If you can't detect any pertinent problems
using these tools, might you be able to answer the following questions:

1.  Do you see the same problem when attempting to use Excel instead of
Access?
2.  What version(s) of Access is installed on the machine?
3.  Do you see the same problem after attempting the following sequence: log
onto the machine as the domain user account used for the service, launch
Access interactively, reboot the machine, log on as the normal machine user,
then attempt to run the service?




Show quoteHide quote
"KLomax" <KLo***@discussions.microsoft.com> wrote in message
news:6FC4E601-D702-42CF-9E64-6BD4F2BAD5C4@microsoft.com...
>I have built an Windows Service, and I am getting an [Access Denied] error
> when I execute the following line.
> Dim AcApp As Access.Application = New Access.Application()
> The Service is Logged on as a Domain.User.
> If I give this user Local Administrator rights, then it works.
> However, I do not want to grant this user account administrator rights.
> Does anyone know if, or what, security policy might be disallowing a
> service
> to Instantiate MSAccess unless the user is an administrator?
>
> Thanks in advance.
> Ken

Bookmark and Share