Create Access 2013 web apps with Sharepoint 2013 and Access 2010

Question

I have to create a web datebase with Access web apps (even though it's not supported anymore). My problem is that there must be a SQL database backend, which forces me to use AWA 2013 or higher (correct me if I'm wrong).

Although I have Sharepoint 2013, my Access is in version 2010. Is it nevertheless possible to create an AWA 2013? Do I in general need Access Desktop to build an AWA or is it independent?

Let's say it works and in a few years my company upgrades to Sharepoint 2016/2019. Can I still use my Access web app locally with version 2016 or 2019?

Answer 1

Hi,

To create an AWA, you'll need Access Services, which runs on an on-premise SharePoint Server (not on Office 365). Are you saying you have this?

If so, you definitely need to upgrade to Access 2013 because Access 2010 cannot create AWAs. If your company upgrades to SP 2016, the AWA may or may not work depending on any updates or patches MS puts out, which could disable AWAs. However, I would suspect AWAs won't work with SP 2019 anymore.

Did you know there are other options to AWA? For example, Zoho or Caspio or PowerApps.

Just my 2 cents...

Answer 2

Thanks for the answer,

Yes, we actual have an on-premise SP-Server with Access Services, but unfortunately no possibility to upgrade to Access 2013. Including the unsafe future of AWA, I think upgrading to PowerApps or something like this is the best way to go.

Thanks, for the alternatives you mentioned. I will take a look at those.

regards,

Christian

Answer 3

Hi Christian,

You're welcome and good luck with your project.