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
    Post Thanks / Like
    0 Post(s)
    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


    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?

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

  2. #2
    Board Regular
    Join Date
    Jun 2015
    Ontario, Canada
    Post Thanks / Like
    1 Post(s)
    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 12: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."

Some videos you may like

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