Access dll missing?

Private Sub lstR_AfterUpdate()
    Dim objPdf As AcroPDF
    Set objPdf = Me.AcroPDF3.Object
    With objPdf
        RetVal = .LoadFile(DLookup("[FilePath]", "Table", "[ID] = " & Me.lstR.Value))
        .setZoom (76)
    End With
    End Sub

Open in new window


The above code works on 32 bit but crashes on 64 bit (Access Runtime), does anyone know how to fix? (It is supposed to display a pdf)
HKFueyAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
OK, well then the DLL is really missing.   You need to install the acrobat software (or whatever software the DLL came from ) on the machine.

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
It's not going to work.  If your using the 64 bit runtime, then it expects all calls to be 64 bit.

There's no real reason to use the 64 bit version of the runtime (and office) and many reasons not to.  This is one of them.

Can you switch to the 32 bit version?  or is it a 64 bit install of Office and you can't switch it (you can't mixed 32 and 64 bit apps within Office - needs to be one or the other).

Jim.
0
 
HKFueyAuthor Commented:
Sorry for the confusion I meant is was running on a 64 bit PC with 32 bit Access Runtime.

This is the same setup as our 32 bit PC's which work OK
0
 
HKFueyAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.