I am using a PowerPoint Class linked OLE object to display a presentation slide on an Access 2007 Form.



Code:
Sub LoadGraphic()
   strPath = "C:\GenericPowerPointFilename.ppt"   
   oleSlide.SourceDoc = strPath
   oleSlide.Action = acOLECreateLink
End Sub
This code works great when I run the Access database on my harddrive, but as soon as I specified strPath as a path on my company's SharePoint server I started to have serious issues:


  1. Leaves instances of POWERPNT.EXE running in the Task Manager
  2. Sometimes the PowerPoint application (which should be running in the background when oleSlide.Action is run) crashes and offers to restart. I do NOT want the user to see this!
  3. Assigning oleSlide.SourceDoc causes "Run-time error: '2101': Setting you entered isn't valid for this property."


Notes:

  • None of these were issues before I changed strPath to a SharePoint server location.
  • Sometimes only one or none of these issues actually occur under seemingly identical run conditions.
  • Issue #1 and #2 usually occur together and seem to be associated with oleSlide.Action. Issue #3 seems to occur independently and occurs on assigning oleSlide.SourceDoc.
  • (I know this is super sloppy but) I can avoid the error in Issue #3 by putting a "While oleSlide.SoureDoc <> strPath" loop around that line of code.
  • The code takes 7 seconds to run if strPath points to my harddrive and closer to 60 seconds pointing to a file on SharePoint. I guess this is to be expected but if there are any tricks to get OLE to access the network file faster, they would be appreciated!


Can anyone shed some light on what is causing my issues?

Click image for larger version. 

Name:	oleProperties.JPG 
Views:	8 
Size:	78.0 KB 
ID:	8512