Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 19th, 2006, 09:25 AM
Authorized User
 
Join Date: Dec 2005
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Default Outlook '03 automation from Access '03 error

Hello,
I am running into problems with creating a new outlook session where i get the error message:

Run-time error '-2147024770 (8007007e)':
Automation error
The specified module could not be found.

I have the Reference box checked for 'Microsoft Outlook 11.0 Object Library'

I have this declared at beginning:

Dim objOutlook As Outlook.Application

Set objOutlook = CreateObject("Outlook.Application")
when it hits this line i get the error message. I tried changing the outlook to Excel and it works fine, firing up excel with it made visible.

Outlook works fine manually openign it, and is installed on the machine.

ive been reading around and read that this may be caused by 'not having the full version of Access installed'
Can anyone help please? any advice and suggestions would mostly be appreciated. Thank you for your time and help.

Derek



 
Old January 19th, 2006, 09:35 AM
Authorized User
 
Join Date: Dec 2005
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Default

could it be the anti-virus application running with an email-related component that blocks scripting?

Would that block the CreateObject?

because my Firewall/AV software has this:
EMON (Email MONitor) – this scanner provides protection from email-borne viruses for MAPI compatible mail clients

Thank you.

derek

 
Old February 3rd, 2006, 06:09 AM
Registered User
 
Join Date: Feb 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have the same problem.
I have temporarily disabled Norton 2006 security and antivirus and the problem doesn't go away.

Thanks
Dave

DaveKGraham





Similar Threads
Thread Thread Starter Forum Replies Last Post
linked forms in Access 07 vs 03 aag Access VBA 0 August 2nd, 2008 04:47 AM
Chap 03 Try It Out -- Error Doug Happ BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 1 February 11th, 2008 02:31 AM
Chapter 03- Chat Server Configuration Error danielson BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 10 March 27th, 2007 11:50 AM
chapter 03 ..i am getting error messages realiest BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 1 July 17th, 2006 03:01 PM
chapter 03 ..i am getting error messages realiest BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 July 7th, 2006 08:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.