Results 1 to 3 of 3
  1. #1
    Lorlai is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jun 2011
    Posts
    107

    Upload Report to SharePoint Library

    I have a report that I want to be uploaded to a SharePoint document library. Is there an automated way to do this? Perhaps in vba? If so, is there a way to set this up as a schedule? For instance, every Friday the report is posted to the SharePoint?



    Thank you!

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    An Access Report is an Access object that can not exist on its own outside Access.

    You would need to save the report as an exterior document - probably PDF or Word - which is easily done.

    Then posting any document to sharepoint is a sharepoint function and not an Access function - so for this you would need to deal with your sharepoint Admin person.

    Automating the whole process will be tricky. Access is 'event driven' not an .exe - which means it is based on the idea that someone is using the application and triggering events. In any case the Access role in this would be to create that document. At that point it is going to be your OS that would automate a task such as posting to sharepoint.

    A different approach of using Access Services feature of sharepoint might be considered in which case the report is published as a web page.

    hope it helps a little,

  3. #3
    Lorlai is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jun 2011
    Posts
    107
    Thank you for your response. I was hoping there might be a way around the event driven basis of access. Is there a way to automate the uploading process? I have a macro that will save my report as a pdf, is there a macro or vba code I could write that will then upload this pdf into the SharePoint document library?


    Thank you!

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

Similar Threads

  1. Report that Pulls from two Forms - Lending Library
    By Surferboy1500 in forum Access
    Replies: 8
    Last Post: 06-07-2011, 12:13 PM
  2. Replies: 1
    Last Post: 05-16-2011, 01:34 PM
  3. Upload (import) Excel Table Info
    By AKQTS in forum Access
    Replies: 2
    Last Post: 04-21-2011, 02:07 PM
  4. library statistics
    By sonia in forum Access
    Replies: 1
    Last Post: 04-11-2010, 12:22 PM
  5. Upload files to access 2007 through web
    By karthikcoep in forum Programming
    Replies: 0
    Last Post: 08-23-2009, 10:04 PM

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