Microsoft Access 2016 web app

Hi,
Please could somebody help me. We want to have an access web app running on a browser.
What are the cheapest options for doing this. We do not need all the extras of Office 365 Enterprise E3.
Can we buy a sharepoint subscription on its own (if so which one would we need to host an access web app)?
Then we could buy Access 2016 as a one off?

Many thanks for your help.
Liz EmpsonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I haven't looked at O365 pricing and what versions include what options lately ... because it's a moving target. What it shows today will likely be different than what it shows tomorrow, lol.
I had an O365 E3 account for two years that costs me $20/month. Whereas I don't use anywhere near all the features, overall it's pretty cool.  I do take advantage of Exchange email, which shows up on all of my devices including cell phone.
I don't know if you can just do the Sharepoint gig alone or not.
So far, Access Web Apps have not been embraced that much in the developer community due to the somewhat limited functionality overall. We are hoping that is going to change.

BTW .... are you aware of  https://access.uservoice.com ?
Has both desktop and web app sections.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
This link is showing Access included at $12/month ... but it's not clear about Web Apps / Sharepoint

https://products.office.com/en-us/business/mostsecure-office-in-the-cloud-enterprise-e5#gq00Q5sVCEVkIzHp.97

I've pinged someone else that should know ...
0
Michael VasilevskySolutions ArchitectCommented:
If you want Access, you're going to have to get a Business plan including Office 365, there is no offering of just Access 2016. The cheapest one (Office 365 ProPlus) is $12/mo. This does not include SharePoint.

For $20/mo. (Office 365 Enterprise E3), you'll get SharePoint as well. There is also no SharePoint only offering or add-on.

While Access 2016 does include "Access Web Apps," know that functionality and customizability is still very limited. For a fully custom app in the browser, SharePoint Online offers a lot of flexibility.

Hope this helps!

Michael
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I confirmed that the 12/month does not include Sharepoint / Access Web apps per se.  It's mainly the desktop version of the products.

I find the $20/month for the E3 account to be a reasonable price for all that is offered.
Another important point is ... wherein the browser portion of Access Web Apps is somewhat limited at this time, you can (and I have done it), one you create the 'web app' from an existing Access back end data structure, which is automatically put in the SQL Azure (managed by Microsoft), you can link an existing Access front end to the Azure backend, getting all of the performance that a SQL Server backend offers.
0
Liz EmpsonCommented:
Thank you for help. Will have to discuss with others cost implications
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Instead of Access Web Apps ... I would suggest looking at (Microsoft) Power Apps :-)
You will need an O365 account to do so.
It's unclear where Web Apps are going.
0
Liz EmpsonCommented:
Ok I'll take look at that. Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.