ACCESS FEED: RE: [MS_AccessPros] Re: Web-Based Microsoft Access?

Kamis, 15 Agustus 2019

RE: [MS_AccessPros] Re: Web-Based Microsoft Access?

Hi Crystal,

Access Web Apps is alive and kicking in Access 2019 (kicking may be overstated but alive certainly 😊) But you do need Sharepoint 2016 or 2019 Enterprise with Access Web App services installed.

We have some videos on using Flow from Access Desktop and PowerApps. From AWA to AWA works in the same way but creating forms in AWA is a breeze as long as the functionality can be simple. When things become complex AWA forms become a nightmare. We've been working on one for two weeks now with two persons. I had to pull all the AWA tricks of my sleeve I gathered from 2012 till 2017. Practically all of them are crazy.

Videos: https://metamicro.nl/nl-nl/Home/Videos

Cheers Rob.

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Sent: donderdag 15 augustus 2019 17:30
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Web-Based Microsoft Access?

hi Rob,

Flow sounds interesting -- have you made any video tutorials on how to use it? Or where would a beginner start?

As for being depreciated, I was referring to Access versions ... nothing past Access 2010 can make an Access web database. The latest version of Access is 2019. I think one reason they failed is because performance was very slow compared to Access desktop applications, as well as being a totally different design experience with a big learning curve. Naturally, when the back-end is in the cloud, things get slower. While remote desktop does have some costs, in the long run I think it wins out because of much better performance especially to reduce frustrating waiting time, being able to use VBA for greater power, and being able to keep company information on premises, which is my preference for those who can backup and maintain their files in-house. To each their own on that though.

(try to keep message history so the thread stays intact, thanks)

Nice to have your input and perspective, Rob!

have an awesome day,
crystal

On 8/14/2019 7:02 AM, r.koelmans@metamicro.nl [MS_Access_Professionals] wrote:

We still have Access Web Apps that you can try for free (for 3 months on SPLA regulations provided we don't charge you anything). It's only deprecated on SharePoint Online, not on SharePoint 2019 Enterprise. SPLA??

Regardless what client or backend you use, always use Flow as the middle tier. Client/Server is truly depreciated. Remote Desktop Licensing is quite expensive.??

The main reason we still use Access Web Apps is its datamacros compile to t-SQL scripts in the server. They run completely independent from Access and will be seen as stored procedures in Flow. The https initiator that invokes the Flow in case can be used from any client including other Flows, Access Web Apps, PowerApps, Access Desktop Applications, Excel, Word, PowerBI, PowerShell etc. The can be both GET and POST services and are easy made safe/secure.

Rob