Posted on 2010-09-07
This question relates to an Access 2003 database running on Windows server 2003. The back end resides on the server, the users (max. 6) have their own copy of the FE and access the BE via Terminal Services.
The following line of code in a module is sometimes causing "Permission Denied" (Error 70) errors:
Set objOutlook = CreateObject("Outlook.Application", "localhost")
Most of the time it works fine - it's in a routine that sends all e-mails from the database using Outlook automation. I can't see any pattern to this error and it can happen to any user on any computer. Any ideas gratefully received