Sleeper: Shared folder on SharePoint

[rolling_zep]

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

[edm7]

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/office/build-and-publish-an-access-database-to-sharepoint-e68bf007-410c-43b2-bf21-322ddbcf5411#__toc262221095

[sherrybo]

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 (https://learn.microsoft.com/en-us/microsoft-365/community/sharepoint-security-a-team-effort)

[potebva]

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/office/build-and-publish-an-access-database-to-sharepoint-e68bf007-410c-43b2-bf21-322ddbcf5411#__toc262221095


thank you for this