Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Services for AWA's for On-Premises SharePoint _ Custom Web App Button

Posted by: lizba Jan 2 2020, 11:40 AM

I am looking into the possibility of an Access Web App. I am using Access 365. I am not sure where to start.
If someone can steer me in the right direction, I would really appreciate it.

Posted by: theDBguy Jan 2 2020, 11:54 AM

Hi Liz. Access Web Apps were discontinued by Microsoft a while back (April 2018, I think), so you will probably have to try something else.

Posted by: RobKoelmans Jan 2 2020, 12:10 PM

Hi Liz,
It seems we're the only ones still providing AWA hosting to third parties like you. Under SPLA terms, you can test and development without fee for three months provided you have no other end users than you as developer. When you have others use your apps before three months you start paying fees. It's 10 euros a month for the first five users, going down to 2,50 for the next ten going down to 23 cents per user over 200 users.

We can also setup a copy of the awa database to a SQL-Server Express instance for you. That way you will have the datamacro's available through Power Automation to just about anything (SharePoint SiteCollections, ASP .Net, PowerApps, PowerBI etc.). We can help you setting up Canvas- and Model-based PowerApps combined with AWA. You would have to gradually phase out the browser part of AWA and be just paying for a virtual machine running SQL-server Express or run the AWA-datamacro created stored procedures in Azure-SQL later on. You can also deploy your own SQL-Express (that has more than enough performance providing you indexed your tables correctly.

In all it may seem some of a hassle but it's a really effective way to get PowerApp applications developed and deployed in a professional 3-tier fashion with no drawbacks at all that you unavoidably would get from a faulty architecture.

If you need to have users up and running really fast, the above may be a good strategy. We can help you setup the AWA in a matter of hours to days, depending on what data and metadata you have available to import and what functionality you need.

It's all in the architecture, the process functionality should run in the database where the data is. not in the client (but a lot of practical issues have developers choose otherwise often). AWA datamacros help knowledge workers and process matter experts create robust and transactional stored procedures that are easily deployed by PowerAutomation/Flow in Office365.

Posted by: lizba Jan 2 2020, 12:19 PM

Ah, that explains a lot

Posted by: lizba Jan 2 2020, 12:20 PM

Thanks Rob
I will sound the company out and see if there would be interested .

Posted by: RobKoelmans Jan 2 2020, 12:24 PM

Liz, good. Send me a PM if you need to know more.