Forum Discussion
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...
Hi! Access Web Apps are deprecated since April 18. they don’t work anymore although there is an option to activate in older access web apps in site features in SharePoint. And there is a Migration Tool from Microsoft to upgrade Access databases to sql bases. Or: You can upload the access database and give your Users a password starting Form. Greets, Eva
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.
- Pfffttt so I can't keep my VBA or anything :(
- 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
