Access data collection

  • Thread starter Thread starter Donald C. Huebner
  • Start date Start date
D

Donald C. Huebner

I have had a problem.. with a new copy of Windows 7 and a new copy of Office
2007 being installed on my computer, I sill cannot get the collect data
through email button/feature to work after reading many help articles. I get
an error saying Outlook is not installed correctly because Access could not
get Outlook to start. When I start Outlook it runs great. Could anyone help
me resolve this problem? I'm not sure where to go to find more information
about this.

Thank you,
Donald C. Huebner
 
You might try getting Access to start Outlook if it isn't already running:

Dim objOutlook As Object
Set objOutlook = GetObject("Outlook.Application")
 
I'm not for sure 100% but I thought it should have not been running if I
turned Outlook off in the task's panle. Even with that checked and off I get
the same error. And, if I need to place that code, where to since this is a
feature of Access 2007 this time?
 
For what it's worth, I'm having the exact same issue on all of the Windows 7
/ Office 2007 machines I have tried, 32-bit and 64-bit.

Other email-related features seem to work (e.g., SendObject).
 
Arvin, this is not really a suitable solution, since the Collect Data via
Email command is unavailble to run programmatically in most cases. For
example, the command is dimmed when a form is active--the underelying table
must be open.

In any case, when I wrote some button click event code to open a table first
and then get an instance of the Outlook application (it must be running), the
command has no effect (it does nothing):

Private Sub cmdCollectData_Click()
DoCmd.OpenTable "tblMembers"
Dim objOutlook As Object
Set objOutlook = GetObject(, "Outlook.Application")
DoCmd.RunCommand acCmdCollectDataViaEmail ' Nothing happens here!
End Sub
 
Don, I figured it out. The culprit is the Microsoft Office Outlook Connector
for Windows Live Hotmail.

The Access data collection add-in apparently fails when the Outlook
Connector is installed and/or the Live mail is the only account type.

On my systems, the Live email accounts are set up as the primary / only
email accounts in Outlook. I have not tried this scenario to see if it woks
against a regular Exchange or POP3 account when the Live mail account is set
up as a secondary account.

Arvin, is there a way to report this interoperability issue to the Microsoft
Access and Oulook Connector teams?
 
I figured it out--the presence of the Outlook Connector for Windows Live is
the culprit, at least when this is the only/primary email account installed
in Outlook (haven't tried it configured another way).
 
Back
Top