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

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

Charlotte … I did as you suggested and ran, as a test, the same code snippet from Word where it performed perfectly. Then, weirdly IT WORKED from Access too. I dunno’ what changed, but I’m happy.
Many thanks,
Gwenda

Reply | Quote