Forum Discussion

HTMcKee's avatar
HTMcKee
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 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. 

office 365
sharepoint

11 Replies

Sort By
  • Sasha_Froyland's avatar
    Sasha_Froyland
    Copper Contributor
    Jan 28, 2019

    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.

  • Eva Vogel's avatar
    Eva Vogel
    Iron Contributor
    Jan 26, 2019
    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
    • jcgonzalezmartin's avatar
      jcgonzalezmartin
      MVP
      Jan 26, 2019
      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
    • HTMcKee's avatar
      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's avatar
        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.

Resources