Re: user permissions for vbscript

You have to set the macro security in Access to a lower level I believe


--
Jim Vierra

"smcqueen" <smcqueen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:64965FF7-DBAE-4B6C-A914-F30090976A63@xxxxxxxxxxxxxxxx
>I am trying to run a vbscript from a user account that belongs to the
> Administrators group on a Windows 2003 Server, but it hangs when it trys
> to
> open an MS Access 2003 database and generates an event id 2001 - 'Rejected
> Safe Mode action : Microsoft Office Access.' for which there is no
> microsoft
> support information. I have to end the process.
>
> I have set the permissions for the DCOM+ object Microsoft Office Access to
> Administrators Group, but that didn't help.
>
> Only the Administrator account can run the following script and maybe
> that's
> by design, but would like to know for sure.
>
> -Myscript.Vbs------------------
> Dim objAccess
> Set objAccess = CreateObject("Access.Application")
> objAccess.OpenCurrentDatabase("mydata.mdb")
> objAccess.DoCmd.RunMacro "ImportIt"
> objAccess.CloseCurrentDatabase
> objAccess.Quit
> Set objAccess = Nothing
> ----------------------------------


.

Relevant Pages

  • user permissions for vbscript
    ... I am trying to run a vbscript from a user account that belongs to the ... I have set the permissions for the DCOM+ object Microsoft Office Access to ... Administrators Group, but that didn't help. ... Set objAccess = CreateObject ...
    (microsoft.public.windows.server.scripting)
  • Re: user permissions for vbscript
    ... MS Access 2003 Macro Security was already set to Low and I have verified the ... which contain the Administrators Group ... >> I have set the permissions for the DCOM+ object Microsoft Office Access to ... >> Dim objAccess ...
    (microsoft.public.windows.server.scripting)
  • Re: machine.inf error (revisited)
    ... David Han ... Verify if the user account you logged on is NOT in Guests or Limited user account ... > group but in the Administrators group. ... >> Hi Rege, ...
    (microsoft.public.windowsxp.embedded)
  • Re: Administrator password?
    ... >> buying it a couple of years ago, and they insisted they had not used a ... >If you other user is a member of the Administrators group, ... >can use this user account to reset the password for the ... >You might try to reset the local Administrator ...
    (microsoft.public.windowsxp.general)
  • Re: Preserving Win XP User Settings when joining a Win2000 Domain
    ... Navigate to the new profile. ... if your old user account was a member of the local Administrators ... Only domain administrators group members are automatically added to ...
    (microsoft.public.win2000.networking)