Results 1 to 3 of 3
  1. #1
    thexxvi is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    May 2015
    Posts
    63

    Unable to export PDF when connected to SharePoint

    Good Afternoon,



    I have a simple database where after a form is completed, the user clicks the submit button and a PDF file is created, then sent to a folder on SharePoint. Everything works perfectly fine when the database is just on my desktop but I need to connect the database to SharePoint. When I link the tables to SharePoint, I no longer can click that submit button to have a PDF file created. It gives me an error message that says "The OutputTo action was cancelled", but doesn't provide any additional information regarding what the underlying cause is.

    Any thoughts as to why this would happen?

    I know it doesn't have anything to do with the file path of the folder because it works on my desktop when not connected to SharePoint just fine.

    The code is below:

    Private Sub SubmitButton_Click()
    Dim NameOfFile As String
    NameOfFile = "
    \\sharepoint.com@SSL\DavWWWRoot\sites\Reviews\" & Me![Processor Name] & "\" & Me![Processor Name] & "_" & Me![ID] & ".pdf"
    Debug.Print NameOfFile
    DoCmd.OutputTo acOutputForm, "Review Form", acFormatPDF, NameOfFile, False, , , acExportQualityScreen
    End Sub


    Thank you.

    Cory

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    it DOES have to do with the path of the folder.
    For some reason Access doesnt like it.

  3. #3
    thexxvi is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    May 2015
    Posts
    63
    Just to clarify, before I connected the database to SharePoint, the export feature worked perfectly fine. The PDF was created and ended up in the correct location.
    When I linked it to SharePoint, it no longer works and I get that error.

    Absolutely nothing in the code or the file path has changed.

    This has happened before on a different database and I think it has something to do with the SharePoint tables/lists that were created (maybe the properties) but I'm not sure.

    I know it's not the file path though because nothing has changed and it works perfectly fine when not connecting to SharePoint.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Unable to export a report to Excel
    By AlReid in forum Import/Export Data
    Replies: 1
    Last Post: 09-24-2014, 11:17 AM
  2. Replies: 3
    Last Post: 12-16-2013, 09:44 AM
  3. Replies: 2
    Last Post: 01-29-2013, 07:01 PM
  4. Replies: 2
    Last Post: 01-05-2012, 11:52 AM
  5. import/export attachments to SharePoint list
    By Cojack in forum Import/Export Data
    Replies: 0
    Last Post: 07-15-2011, 01:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums