Forum Discussion
Access Front End in Sharepoint
- If he uploads the access database to SPO, it's not going to work. Best he can do here is to "migrate" the App to PowerApps using SPO lists as backend
Hi HTMcKee! To get familiar with translate an ER Modelling within PowerApps I also found this: https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/Relational-Database-Design-fundamentals-Implementing-a-One-to/ba-p/200521
I think this article helps understanding why the relationship between tables is fundamental to plan and to install a powerApp. So first you have to examine, which relationships in which tables you already have in your Access Database, then you have to "translate" and build these in a PowerApp.
Hope that helps. Greets, Eva.
- And indeed there are examples to migrate form Acess Web App (that's not our case) to PowerApps: https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/How-I-migrated-my-Access-Web-App-to-PowerApps-Part-1/ba-p/81395 So the fundamentals are valid, but not the procedure https://www.quora.com/How-can-we-migrate-data-from-MS-Access-to-SharePoint-Online-Office-365-without-using-the-MS-Access-client
- 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
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.
