I've switched from access 2003 to access 2007 and have found lots of 
differences.  I download the developers addins and have been using it to 
package up the program and send it out.  I've run into a problem in that it 
doesn't send out one of the references I use in the program.  The end user 
ends up getting a Max(mid([Comment],1,4)) Function is not available.  What I 
have found out that a reference msoutl.olb is missing.  Do I have to include 
it to the addins when I package up the program?  I thought all references 
were included.   I don't want to send out the package and have a problem with 
this missing reference.
Thanks for any help.

On Sat, 19 Dec 2009 11:32:01 -0800, CD Tom
<CDTom@discussions.microsoft.com> wrote:

You thought wrong. Outlook cannot be redistributed with your app.
Rather it should already been installed on the target machine, and if
it is your reference should resolve correctly.

-Tom.
Microsoft Access MVP


>I've switched from access 2003 to access 2007 and have found lots of 
>differences.  I download the developers addins and have been using it to 
>package up the program and send it out.  I've run into a problem in that it 
>doesn't send out one of the references I use in the program.  The end user 
>ends up getting a Max(mid([Comment],1,4)) Function is not available.  What I 
>have found out that a reference msoutl.olb is missing.  Do I have to include 
>it to the addins when I package up the program?  I thought all references 
>were included.   I don't want to send out the package and have a problem with 
>this missing reference.
>Thanks for any help.

CD Tom <CDTom@discussions.microsoft.com> wrote:

>I've switched from access 2003 to access 2007 and have found lots of 
>differences.  I download the developers addins and have been using it to 
>package up the program and send it out.  I've run into a problem in that it 
>doesn't send out one of the references I use in the program.  The end user 
>ends up getting a Max(mid([Comment],1,4)) Function is not available.  What I 
>have found out that a reference msoutl.olb is missing.  Do I have to include 
>it to the addins when I package up the program?  

That sounds like Outlook and that machine doesn't have your version of
Outlook or Outlook isn't installed..  As Tom states you can't
distribute it either.   So you want to use late binding.

Late binding means you can safely remove the reference and only have
an error when the app executes lines of code in question.  Rather than
erroring out while starting up the app and not allowing the users in
the app at all.  Or when hitting a mid, left or trim function call.  

This also is very useful when you don't know  version of the external
application will reside on the target system.  Or if your organization
is in the middle of moving from one version to another.

For more information including additional text and some detailed links
see the "Late Binding in Microsoft Access" page at
http://www.granite.ab.ca/access/latebinding.htm

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/
Granite Fleet Manager http://www.granitefleet.com/