• Subject: Problem automating Outlook in Windows 7 from VB6 and Access
  • Author: Tony Toews
  • Date: 09 Oct 2010
  • References:
Folks

I have a a VB6 EXE (Auto FE Updater if anyone cares) which does a
bunch of things and then starts up Microsoft Access. A user, who has
done some good troubleshooting, has a problem within Windows 7.

If he starts up the Access FE MDE file with the VB6 exe it fails on
the following line of code.
Set olApp = GetObject(, "Outlook.Application")
if Outlook is already running. A second copy of Outlook briefly
appears in the taskbar.

If Outlook isn't already running then it works. But of course most
folks who run Outlook in a corporate environment run it all the time.

If he starts up the Access FE MDE with a batch file it works just
fine.

If he clicks on the Access FE MDE from Windows Explorer it works just
fine.

All of the above works just fine on a Windows XP system. This
problem is new to Windows 7

This sounds suspiciously like a permissions problem of some sort I had
when Win Vista first came out and I had to put in a manifest file in
the VB6 exe.

Tony
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
09 Oct 2010Problem automating Outlook in Windows 7 from VB6 and Access.Tony Toews
11 Oct 2010\ Re: Problem automating Outlook in Windows 7 from VB6 and Access.Ken Slovak
11 Oct 2010   |- Re: Problem automating Outlook in Windows 7 from VB6 and Access.Tony Toews
11 Oct 2010   |  \ Re: Problem automating Outlook in Windows 7 from VB6 and Access.Ken Slovak
11 Oct 2010   |     \ Re: Problem automating Outlook in Windows 7 from VB6 and Access.Tony Toews
12 Oct 2010   \ Re: Problem automating Outlook in Windows 7 from VB6 and Access.Tony Toews
13 Oct 2010      \ Re: Problem automating Outlook in Windows 7 from VB6 and Access.Ken Slovak
13 Oct 2010         \ Re: Problem automating Outlook in Windows 7 from VB6 and Access.Tony Toews
14 Oct 2010            \ Re: Problem automating Outlook in Windows 7 from VB6 and Access.Ken Slovak
14 Oct 2010               \ Re: Problem automating Outlook in Windows 7 from VB6 and Access.Tony Toews
14 Oct 2010                  \ Re: Problem automating Outlook in Windows 7 from VB6 and Access.Ken Slovak
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)