Missing reference

[CD Tom]

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.

 

[Tom van Stiphout]

On Sat, 19 Dec 2009 11:32:01 -0800, CD Tom

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

 

[Tony Toews [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?

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/