Link to home
Start Free TrialLog in
Avatar of Biggles1
Biggles1Flag for United States of America

asked on

Access References

I have an Access Database which uses MS Outlook to send Emails.  This requires opening the "References" form (from VBA) and checking the Microsoft Outlook checkbox.

This is a "Split" Database with separate "front ends" running on several PC's (linked to a common data "back end" on the server.

However not all PC's are running the same version of Outlook.  

QUESTION:
How do I make the Access "front end" on each PC automatically detect the version of Outlook installed and set the correct Outlook Reference?

Help would be appreciated!!!

Biggles
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

You need to use what is called late binding rather then early binding as you are now:

Using early binding and late binding in Automation
http://support.microsoft.com/kb/245115

With late binding, you don't set a reference and declare everything as OBJECT rather then something specific.

Late binding avoids references problems, but it does carry a performance cost.  Also, you loose intellisense when developing.  For the latter, some developers develop with early binding, then switch to late binding when they deploy the app.

And of course the other option is to not use Outlook for sending e-mails.

Jim.
Avatar of Biggles1

ASKER

Thanks Jim for your quick response.  How would I go about not using Outlook to send Emails?

George (aka Biggles)
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial