Question missing or broken reference to the file 'MSOUTL.OLB' version 9.2."

wjburke2

Registered User.
Local time
Today, 17:38
Joined
Jul 28, 2008
Messages
194
I have built a database using access 2007, using the Access 2003 mdb file format. My users have Access 2007 Runtime installed. Several of my users are getting the following error message when they try to open the database.

"Your CPMS database or project contains a missing or broken reference to the file 'MSOUTL.OLB' version 9.2."

Has anyone any ideas what is causing this? When designing this database I included code automate sending emails when reports are ready. I included a reference to Microsoft Outlook object library 11, could this be the problem? It seems weird that I would only see the message now when I am trying to install updates. The same program, with the same references have been working on these computers for months.
 
You need to use a late binding method to build your emails through the Outlook object. Try the code I posted in this thread Outlook 2007 & E-mails instead of what you are using to avoid your problem. Do not forget to remove your reference to Outlook 11.
 
Thanks G, it looks like you have put a lot of work into getting this going. I am still not sure why it was working and now is not. As Access goes I may never know. The only thing I can think of is I converted it to an accdr then back to a mdb. It was that or one of those updates that MS is always dolling out. Could this have updated or changed the references.
 
Not sure, I always avoid using references to specific versions of office apps. Use the code I pointed you to and you will not have to worry about what version of access your users have.
 
what happens is you develop with office 2007

your code builds in a reference to the version of outlook YOU have
--------

then you put it on a target machine that has an EARLIER version of outlookm and access cannot resolve this automatically.

it can the other way - ie you build with Outlook 2003, and you put it on a machnie with Outlook 2007. No problem!

design a module, then check tools/references and see which library is missing. THEN MANUALLY pick the version you DO have.
 
Thanks Huskey, I believe your right. I think the problem is I don't have 2003 on my development machine and the users have A2003 and/or A2007 runtime. I started this job 5 years ago using A2003 as a RDE demo- development tool. By the time it was fully developed it was huge so we decided to upgrade to A2007 and keep it on Access. I just worry the Access isn't robust enough for where we are going. Right now its just production. I want to tie in inventory and shipping. We ship 7,000,000 pices a month in hundreds of trucks.
 
access is extremely capable. at some point, you may need to move to a different back end, but judicious design can help greatly. then it depends on how many users, and their activity mix.

as long as its managing, stick with it.
 
GHudson, I have a problem. I put your code into my application. I am getting an error in the Function SetupOutlookEmail when it trys to execute outItem.To = sTo. I get a nasty message telling me "A program is trying to access e-mail addresses you have stored in Outlook. Do you want to allow this? :eek: I click yes and it proceeds giving me this message for each field. Then I get an error that there are no names in To, CC, or BCC. No email is send. What am I doing wrong? Have you had this problem, and is there a fix?
 
How are you defining the values for the sTo and sCC strings? In my sample code I posted I am hard coding them in the example.

Code:
    sTo = "johndoe@widgets.com; marysmith@widgets.com"
    sCC = "me@widgets.com"

Please post your entire code for creating your email so we can try to spot the problem.
 
I did modify the your sub a little.
I use the pased fields to populate the values in your sub

Public Sub SendEmail(strTo As String, strSubject As String, strBody As String, Optional strCC As String, Optional srtReplyTo, Optional strAttachments As String) ....

Here is my code to call it:

Private Sub btnExpPackage_Click()
On Error GoTo Err_btnExpPackage_Click

Dim strDocName As String
Dim strOpenArgs As String

Dim strTo As String
Dim strSubject As String
Dim strBody As String
Dim strReplyTo As String

' ********* old code ***********
' Dim appOutLook As Outlook.Application
' Dim MailOutLook As Outlook.MailItem

'*****************************************************
'*** Send an emial when the process is completed ****
'*****************************************************
strCycleDate = Format(gblReportDate, "mmdd")
strRepPath = DLookup("ReportPath", "ProgramDefaults", "Default = true")
strRepName = "Inq-" & strCycleDate & " Memo-Package Sheets.PDF"

strOutputTo = strRepPath & Year(gblReportDate) & "\Cycle " & strCycleDate & _
"\Inq-" & strCycleDate & " Memo-Package Sheets.PDF"

strBody = "The Fulfillment Database has been approved and the components exported <br><br>" _
& "<a href=""" & strOutputTo & """>" & strOutputTo & "</a>"

strType = DLookup("TypeFlag", "ProgramDefaults", "Default = true")
If strType = "T" Then
strTo = "wBurke@tmc.com"
ElseIf strType = "P" Then

strTo = "THEFF@tmc.com;" & _
"mWard@tmc.com;" & _
"cRoy@tmc.com;" & _
"mHooper@tmc.com;" & _
"wBurke@tmc.com;" & _
"lCoopper@tmc.com"
Else
GoTo Exit_btnExpPackage_Click
End If

strSubject = "Fulfillment Database is Updated"
strReplyTo = "122programming@tmc.com"

' This calls the Send Email module in modSend_Email
SendEmail strTo, strSubject, strBody, , strReplyTo

' ************** old code *******************
' Set appOutLook = CreateObject("Outlook.Application")
' Set MailOutLook = appOutLook.CreateItem(olMailItem)
'
' With MailOutLook
' .BodyFormat = olFormatHTML ' olFormatRichText
' .To = strTo
' .Subject = "Fulfillment Database is Updated"
' .HTMLBody = strBody
' .DeleteAfterSubmit = True 'This lets Outlook send the note without storing it in your sent bin
' .Send
' End With


Exit_btnExpPackage_Click:
Exit Sub

Err_btnExpPackage_Click:
MsgBox Err.Description
Resume Exit_btnExpPackage_Click

End Sub
 
Last edited:
I have come to somewhat of a dead end as far as Outlook is concerned. I quess MS has decided, on the users behalf, not to allow emails from outside programs. Proably wisely. I have a third party package called Blat I am going to try that and see how far I get. If antone has any ideas please help I am stuck.
 
I got exactly the same issue - well, version 9.4 not 9.2 ( shortly after customising my ribbon using XML and changing settings ? ) but I'm gonna look at this 'Late Binding' solution. If it works, it looks ideal. Wish me luck.
 

Users who are viewing this thread

Back
Top Bottom