Command line to open file on sharepoint

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Command line to open file on sharepoint

  1. #1
    Board Regular
    Join Date
    Mar 2009
    Posts
    56
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Command line to open file on sharepoint

     
    Good morning.

    I have had a SQL database running for years at our company that uses MS Access as a front end and it works great. I have it setup so that when the user wants to view a document (pdf for example) they can just click on a button in the Access front end and the database knows the file location on our server and pulls it up.

    Our company is now wanting to move all of these sort of files (pdf, doc, xls) off of a 'normal' server and onto SharePoint365. I know the path to the file but Access doesn't seem to understand it.

    For example currently I would use this statement to pull up the document:

    Application.FollowHyperlink "M:\ED Write Ups" & [Document_ID] & ".pdf"

    However the same logic doesn't appear to work in SharePoint.

    The path in SharePoint would be

    https:\\ph.sharepoint.com/teams/nclin/BAM/ReportData/Forms/AllItems.aspx?id=%2Fteams%2Fnclin%2FBAM%2FReportData%2FAutomated%20Bed%20Snapshots%2FHistorical%20Snapshots

    and the file name (if hard coded) would be "Bed Snapshot - 2016-12-15 07.pdf

    Is it possible for MS Access to reference and display a file from Sharepoint?

    thanks!
    Last edited by Ethvia; Dec 6th, 2017 at 07:51 AM. Reason: trying to get path for sharepoint not to show up as a link

  2. #2
    Board Regular
    Join Date
    Jun 2015
    Location
    Ontario, Canada
    Posts
    1,356
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Command line to open file on sharepoint

      
    I see no answers yet, so I'll contribute what little I know of this. From other posts here or elsewhere (I can't recall where) seems to me there's no way to serve up a file to Access from SharePoint without checking it out. At least that was the determination when said file was an Access db. Access can check in and out a file from SP, but in the other case it made no sense since the db itself was intended to be shared.

    Also, when I had to write Access data to a SP workbook, I had to use the standard server syntax. While the server did seem to have a url type of address (it was reachable via browser) it also had a standard server address which I had to use (e.g. \\SomeServer\).
    Hope that helps.
    Last edited by Micron; Dec 7th, 2017 at 01:56 AM. Reason: grammar
    Tips for posting problems:
    1) "doesn't work" doesn't help. Post error message text/numbers and/or state what's happening.
    2) if posting code or sql, use code tags; specify on which code line errors occur, if applicable
    3) try to be specific; assume we know nothing about your issue - because we don't!

    Make all suggested changes in copies of your database or to its objects.

    "1 out of 1010 people understand binary. The other 1001 don't."

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com