Forum Discussion

Copper Contributor

Jan 26, 2019

Access Front End in Sharepoint

Hi, I have created a database and coverted the table to a Sharepoint list. This is working well but I see that there used to be an option to createa a "custom web app" in Access so that users c...

office 365

sharepoint

HTMcKee

Copper Contributor

Jan 26, 2019

That's really useful thank you. I'm a complete beginner, do you have any link to some simple guides that would help me please? Eva Vogel

Eva Vogel

Iron Contributor

Jan 26, 2019

Hi HTMcKee! There are tons of doing a login form in Access, here is one:

https://www.youtube.com/watch?v=356ylQn6kkA

dealing with VBA and works with local database without being in the cloud.Unfortunately VBA doesn´t work in OneDrive.

The good news is that you can create an O365 user group in your Admin Center e.g. named "Access Database Users", take your users to this group who should be given access. Then upload that database either on OneDrive or on SharePoint, then share this database only with this new group! Office 365 User Groups can then access your database without certain login form. The obvious advantage is, that you can easily manage permissions not with single users, BUT only with users being in that group!And you can then share ANY file with that group globally, not only with your database.

https://www.youtube.com/watch?v=rSqLgLL5xI4

Hope that helps. Greets, Eva.