[AccessD] Access 2010+ with SharePoint

[Jim Dettman]

<<I would like to know if the change to Azure has
improved performance.>>

 markedly so.   With the SharePoint lists, about 5,000 records was it before
you had problems.

 Now it's full SQL for the BE.

 And note, you only get Azure if your running this with Office 365.  If your
running on prem, then it's SQL Server 2012.

Jim.
-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Mark Simms
Sent: Thursday, December 31, 2015 09:32 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2010+ with SharePoint

Again, without a Javascripting capability, these apps are worthless.

Microsoft could easily create a VBA-to-Javascript facility....
But they do not....and this is on purpose.

However, and interestingly, I would like to know if the change to Azure has
improved performance.

>
>   A2013 and A2016 have something called Web Apps, which are a change
> from
> Web Databases in A2007/2010.
>
>   With 2007/2010, the FE was in SharePoint, as well as the data, which
> was
> stored in SharePoint Lists.
>
>   For A2013 and up, the FE is still in SharePoint, but the data is now
> stored in SQL Server in the cloud (Azure).
>
>   Thoughts are; not good for much.   Web Apps have a limited set of
> forms
> and controls, only a half dozen so events, and you have to use macros.
> There is also no reporting.  In short, they are good for nothing but
> basic
> CRUD operations.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com