Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    vancouver, BC, Br. Columbia
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Outlook automation - permission denied (Access 97/Outlook 98)

    I have a front-end working fine on several machines with one exception. One workstation generates an error at the line:

    Set objOutlook = New Outlook.Application

    The error is #70 - Permission Denied.

    I tried using GetObject - which generated error #429 "ActiveX component can't create object" - and CreateObject which gives error #70 Permission Denied.

    I'm particularly frustrated because this line works fine 4 out of 5 workstations.
    Gwenda <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Outlook automation - permission denied (Access 97/Outlook 98)

    Then start by looking at what's different about that machine: versions of OS and software, security patches on Windows/Office/Outlook. I doubt you'll find this to be an Access problem, and you can test that ny attemting the same automation code from another Office app.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    vancouver, BC, Br. Columbia
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook automation - permission denied (Access 97/Outlook 98)

    Charlotte ... I did as you suggested and ran, as a test, the same code snippet from Word where it performed perfectly. Then, weirdly <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35> IT WORKED from Access too. I dunno' what changed, but I'm happy.
    Many thanks,
    Gwenda <img src=/S/joy.gif border=0 alt=joy width=23 height=23>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •