locked
retrieve name site RRS feed

  • Question

  • van you retrieve the name of the sharepointsite where the access database is placed ?

    Saturday, May 19, 2018 2:33 PM

Answers

  • Hello tekoko10,

    You could try to use below code to return its PublishURL that should be what you want.

    Sub test()
    MsgBox CurrentDb.Properties("PublishURL")
    End Sub

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by tekoko10 Tuesday, May 22, 2018 10:39 AM
    Tuesday, May 22, 2018 10:09 AM

All replies

  • Retrieve from where? Are you talking about a web app?
    Saturday, May 19, 2018 3:29 PM
  • Hello tekoko10,

    Could you please detail us your issue? What application are you developing? 

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, May 22, 2018 5:30 AM
  • i just wanted to know if i could see on which SharePoint site the database was located , of course it is just the path , i was confused ,soryy . if i could delete this question i would do it  :):):) sorry !
    Tuesday, May 22, 2018 6:38 AM
  • Hello tekoko10,

    You could try to use below code to return its PublishURL that should be what you want.

    Sub test()
    MsgBox CurrentDb.Properties("PublishURL")
    End Sub

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by tekoko10 Tuesday, May 22, 2018 10:39 AM
    Tuesday, May 22, 2018 10:09 AM