Best way to view ole files

J

JWS315

What is the best way to allow users to view ole linked files that I have
stored the file name in my database? I am currently using an unbound OLE
field with the following code:

If Right(Forms!Figurelist!lstFiglist, 3) = "doc" Then
Forms!Figurelist!pptFrame.Class = "Microsoft Word"
Else
Forms!Figurelist!pptFrame.Class = "Microsoft Powerpoint"
End If
Forms!Figurelist!pptFrame.OLETypeAllowed = acOLELinked
Forms!Figurelist!pptFrame.SourceDoc = Forms!Figurelist!lstFiglist
Forms!Figurelist!pptFrame.Action = acOLECreateLink

This seems to work but it is slow. I have considered just allowing the user
to press a "View" button and use the FollowHyperlink to open the file in the
native application.

TFH
Jerry
 
Top