Access Front End in Sharepoint

%3CLINGO-SUB%20id%3D%22lingo-sub-326014%22%20slang%3D%22en-US%22%3EAccess%20Front%20End%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326014%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20database%20and%20coverted%20the%20table%20to%20a%20Sharepoint%20list.%26nbsp%3B%20This%20is%20working%20well%20but%20I%20see%20that%20there%20used%20to%20be%20an%20option%20to%20createa%20a%20%22custom%20web%20app%22%20in%20Access%20so%20that%20users%20could%20open%20the%20front%20end%20in%20a%20web%20browser.%26nbsp%3B%20Is%20this%20still%20possible%3F%26nbsp%3B%20I%20can't%20find%20this%20template%20anywhere.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20want%20users%20to%20be%20able%20to%20open%20my%20front%20end%20in%20a%20browser%20so%20they%20don't%20need%20Access%20installed%20locally.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-326014%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326741%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Front%20End%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326741%22%20slang%3D%22en-US%22%3E%3CP%3EMicrosoft%20Access%20is%20the%20world's%20fastest%20rapid%20application%20platform%20on%20the%20planet%20but%20when%20you%20need%20more%20power%2C%20please%20consider%20Googling%20%22Help4Access%20Migration%20Services%22%20to%20read%20free%20case%20studies%20which%20can%20help%20you%20determine%20a%20migration%20path%20forward.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326112%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Front%20End%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326112%22%20slang%3D%22en-US%22%3EI'm%20sorry%2C%20I%20didn't%20mean%20it%20to%20come%20across%20ungrateful%20for%20the%20support%20or%20anything.%20I'm%20thankful%20to%20be%20pointed%20in%20right%20direction.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326109%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Front%20End%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326109%22%20slang%3D%22en-US%22%3ESometimes%20life%20isn%E2%80%99t%20fair.%20It%20depends%20on%20what%20you%20are%20doing%20with%20it.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326048%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Front%20End%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326048%22%20slang%3D%22en-US%22%3EPfffttt%20so%20I%20can't%20keep%20my%20VBA%20or%20anything%20%3A(%3C%2Fimg%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326039%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Front%20End%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326039%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F272466%22%20target%3D%22_blank%22%3E%40HTMcKee%3C%2FA%3E!%20To%20get%20familiar%20with%20translate%20an%20ER%20Modelling%20within%20PowerApps%20I%20also%20found%20this%3A%20%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community-Blog%2FRelational-Database-Design-fundamentals-Implementing-a-One-to%2Fba-p%2F200521%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community-Blog%2FRelational-Database-Design-fundamentals-Implementing-a-One-to%2Fba-p%2F200521%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20this%20article%20helps%20understanding%20why%20the%20relationship%20between%20tables%20is%20fundamental%20to%20plan%20and%20to%20install%20a%20powerApp.%20So%20first%20you%20have%20to%20examine%2C%20which%20relationships%20in%20which%20tables%20you%20already%20have%20in%20your%20Access%20Database%2C%20then%20you%20have%20to%20%22translate%22%20and%20build%20these%20in%20a%20PowerApp.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps.%20Greets%2C%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326033%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Front%20End%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326033%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%20and%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F272466%22%20target%3D%22_blank%22%3E%40HTMcKee%3C%2FA%3E%26nbsp%3B%20!%20Thanks%20for%20your%20interludes.%20I'll%20check%20this%20out.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreets%2C%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326026%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Front%20End%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326026%22%20slang%3D%22en-US%22%3EAnd%20indeed%20there%20are%20examples%20to%20migrate%20form%20Acess%20Web%20App%20(that's%20not%20our%20case)%20to%20PowerApps%3A%20%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community-Blog%2FHow-I-migrated-my-Access-Web-App-to-PowerApps-Part-1%2Fba-p%2F81395%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community-Blog%2FHow-I-migrated-my-Access-Web-App-to-PowerApps-Part-1%2Fba-p%2F81395%3C%2FA%3E%20So%20the%20fundamentals%20are%20valid%2C%20but%20not%20the%20procedure%20%3CA%20href%3D%22https%3A%2F%2Fwww.quora.com%2FHow-can-we-migrate-data-from-MS-Access-to-SharePoint-Online-Office-365-without-using-the-MS-Access-client%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.quora.com%2FHow-can-we-migrate-data-from-MS-Access-to-SharePoint-Online-Office-365-without-using-the-MS-Access-client%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326024%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Front%20End%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326024%22%20slang%3D%22en-US%22%3EIf%20he%20uploads%20the%20access%20database%20to%20SPO%2C%20it's%20not%20going%20to%20work.%20Best%20he%20can%20do%20here%20is%20to%20%22migrate%22%20the%20App%20to%20PowerApps%20using%20SPO%20lists%20as%20backend%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326022%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Front%20End%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326022%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F272466%22%20target%3D%22_blank%22%3E%40HTMcKee%3C%2FA%3E!%20There%20are%20tons%20of%20doing%20a%20login%20form%20in%20Access%2C%20here%20is%20one%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D356ylQn6kkA%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D356ylQn6kkA%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edealing%20with%20VBA%20and%20works%20with%20local%20database%20without%20being%20in%20the%20cloud.Unfortunately%20VBA%20doesn%C2%B4t%20work%20in%20OneDrive.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20good%20news%20is%20that%20you%20can%20create%20an%20O365%20user%20group%20in%20your%20Admin%20Center%20e.g.%20named%20%22Access%20Database%20Users%22%2C%20take%20your%20users%20to%20this%20group%20who%20should%20be%20given%20access.%20Then%20upload%20that%20database%20either%20on%20OneDrive%20or%20on%20SharePoint%2C%20then%20share%20this%20database%20only%20with%20this%20new%20group!%20Office%20365%20User%20Groups%20can%20then%20access%20your%20database%20without%20certain%20login%20form.%20The%20obvious%20advantage%20is%2C%20that%20you%20can%20easily%20manage%20permissions%20not%20with%20single%20users%2C%20BUT%20only%20with%20users%20being%20in%20that%20group!And%20you%20can%20then%20share%20ANY%20file%20with%20that%20group%20globally%2C%20not%20only%20with%20your%20database.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DrSqLgLL5xI4%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DrSqLgLL5xI4%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps.%20Greets%2C%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326018%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Front%20End%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326018%22%20slang%3D%22en-US%22%3EThat's%20really%20useful%20thank%20you.%20I'm%20a%20complete%20beginner%2C%20do%20you%20have%20any%20link%20to%20some%20simple%20guides%20that%20would%20help%20me%20please%3F%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F153902%22%20target%3D%22_blank%22%3E%40Eva%20Vogel%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326016%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Front%20End%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326016%22%20slang%3D%22en-US%22%3EHi!%20Access%20Web%20Apps%20are%20deprecated%20since%20April%2018.%20they%20don%E2%80%99t%20work%20anymore%20although%20there%20is%20an%20option%20to%20activate%20in%20older%20access%20web%20apps%20in%20site%20features%20in%20SharePoint.%20And%20there%20is%20a%20Migration%20Tool%20from%20Microsoft%20to%20upgrade%20Access%20databases%20to%20sql%20bases.%20Or%3A%20You%20can%20upload%20the%20access%20database%20and%20give%20your%20Users%20a%20password%20starting%20Form.%20Greets%2C%20Eva%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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. 

11 Replies
Highlighted
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
Highlighted
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
Highlighted

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.

We are aware of the "No Password Needed" bug. A newer version of creating a classic login form can be found at https://youtu.be/2BYIHYe00wM or look in the wo...
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
Highlighted
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
Highlighted
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-Pow... 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...
Highlighted

Hi @Juan Carlos González Martín and @HTMcKee  ! Thanks for your interludes. I'll check this out. 

 

Greets, Eva.

Highlighted

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.

Highlighted
Pfffttt so I can't keep my VBA or anything :(
Highlighted
Sometimes life isn’t fair. It depends on what you are doing with it.
Highlighted
I'm sorry, I didn't mean it to come across ungrateful for the support or anything. I'm thankful to be pointed in right direction.
Highlighted

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.