Jan 25 2019 11:25 PM
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 could open the front end in a web browser. Is this still possible? I can't find this template anywhere.
I just want users to be able to open my front end in a browser so they don't need Access installed locally.
Thank you.
Jan 25 2019 11:36 PM
Jan 25 2019 11:48 PM
Jan 26 2019 12:17 AM
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.
Jan 26 2019 12:32 AM
Jan 26 2019 12:34 AM
Jan 26 2019 12:57 AM
Hi @Juan Carlos González Martín and @HTMcKee ! Thanks for your interludes. I'll check this out.
Greets, Eva.
Jan 26 2019 01:54 AM
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...
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.
Jan 26 2019 02:53 AM
Jan 26 2019 09:38 AM
Jan 26 2019 09:45 AM
Jan 28 2019 10:54 AM
Microsoft Access is the world's fastest rapid application platform on the planet but when you need more power, please consider Googling "Help4Access Migration Services" to read free case studies which can help you determine a migration path forward.