Consulting

Results 1 to 6 of 6

Thread: Sleeper: Shared folder on SharePoint

  1. #1

    Sleeper: Shared folder on SharePoint

    Hi All,

    We have multiple Access databases on our shared folder used by our team.
    Now the company policy requires all shared folders to be on SharePoint.
    Is putting Access databases on Sharepoint advisable for multi user environment? Does this mean a User has to check out to work on their edits and check in?
    How to go about this since some of the FEs have their links to one Master BE. Will that cause any locking or performance issues?
    Also, the databases contain sensitive personal data which makes me wary of SharePoint on account of security. How to restrict the security while in SP?

    TIA

  2. #2
    VBAX Newbie
    Joined
    Aug 2023
    Posts
    1
    Location
    Here is an article about Sharing on Sharepoint... Not sure it's still relevant as Microsoft is pushing it's PowerPlatform. If you have apps built in access may not be useable in Sharepoint.

    https://support.microsoft.com/en-au/...__toc262221095

  3. #3
    VBAX Newbie
    Joined
    Nov 2023
    Posts
    1
    Location
    Quote Originally Posted by rolling_zep View Post
    Hi All,

    We have multiple Access databases on our shared folder used by our team.
    Now the company policy requires all shared folders to be on SharePoint.
    Is putting Access databases on Sharepoint advisable for multi user environment? Does this mean a User has to check out to work on their edits and check in?
    How to go about this since some of the FEs have their links to one Master BE. Will that cause any locking or performance issues?
    Also, the databases contain sensitive personal data which makes me wary of SharePoint on account of security. How to restrict the security while in SP?

    TIA
    There are different ways to share an Access database on SharePoint, depending on your needs and preferences. Each option has its own advantages and disadvantages, depending on factors such as performance, functionality, compatibility, security, and user experience. You can find more information and guidance on how to choose the best option for your scenario in this article: Managing SharePoint Online Security: A Team Effort | Microsoft Learn

  4. #4
    VBAX Newbie
    Joined
    Jan 2024
    Posts
    1
    Location
    Quote Originally Posted by edm7 View Post
    Here is an article about Sharing on Sharepoint... Not sure it's still relevant as Microsoft is pushing it's PowerPlatform. If you have apps built in access may not be useable in Sharepoint.

    https://support.microsoft.com/en-au/...__toc262221095

    thank you for this

  5. #5
    Quote Originally Posted by edm7 View Post
    Here is an article about Sharing on Sharepoint... Not sure it's still relevant as Microsoft is pushing it's PowerPlatform. If you have apps built in access may not be useable in Sharepoint. Run 3

    https://support.microsoft.com/en-au/...__toc262221095
    Does that cause any locking or performance issues?

  6. #6
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,217
    Location
    Welcome to VBAX cojeannine. If you follow that link, you will see the Microsoft no longer recommend using Access 2010 and Access Services for new Access web databases.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Posting Permissions

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