[AccessD] MS Access Web Apps Javascript(?) Add-Ins - Was:Re[2]: Access and source control

Jim Dettman jimdettman at verizon.net
Mon Jan 25 07:51:43 CST 2016



 I might be living in a cave<g>, but Office Add-Ins have been around for a
while already and at least in the Access world, no one has done anything
with them (I haven't seen them anywhere else either).

 Access web apps landed with a tremendous thud.

 Consider that we are now almost four years since introduction, and I have
not seen a single app outside of the HR app written by Julian on the App
store, and none anywhere else.  On Experts-Exchange, I think we've answered
a couple dozen questions at most on web apps. In the MVP community, I
believe there are only two MVP's that have done a web app besides Julian and
they more or less gave up on them.

 I'd rather not be so overly negative on them, but they are so limited, you
just cannot do anything meaningful with them expect in a very limited scope.

  Check out this page:

https://msdn.microsoft.com/en-us/library/office/jj250134.aspx

 Which just about fully describes what you have available to you. For a
developer, there's not a lot there to work with.  They have added some newer
features in 2016, such as e-mailing (only within your own domain though),
downloading of data into Excel, and some linking to Power BI, but still your
limited fundamentally by what you can do in the web app.

 Microsoft is simply aiming for the power users and nothing else.

Jim.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Salakhetdinov Shamil
Sent: Sunday, January 24, 2016 02:18 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] MS Access Web Apps Javascript(?) Add-Ins - Was:Re[2]:
Access and source control

 Hi Jim --

<<<
They are great for throwing together a basic app that does CRUD operations
>>>
Yes, that was my impression too.
But recently released Office Add-Ins together with Office UI Fabric and
other related technologies seems to be the "game changers" as they are
HTML/CSS/JavaScript -based/-driven and only "the skies are limits" in this
case...

Thank you

-- Shamil

>Sunday, January 24, 2016 12:30 PM -05:00 from "Jim Dettman"
<jimdettman at verizon.net>:
>
>Shamil,
>
><<It looks like using VS 2015 "dumb" MS Access Web Apps can be
>extended/enhanced by using Office365/SharePoint JavaScript(?) Add-ins by so
>making them real candidates for modern "web solutions">>
>
> While to a certain extent that's true, I think if you dig into the Access
>Web Apps, you'll find yourself so restricted you won't find them worth the
>effort despite the ability to extend them.
>
> There are only a few forms and a handful of controls that you can use, and
>almost no events to speak of.  They are great for throwing together a basic
>app that does CRUD operations, but that's about it.  Try to add any real
>logic and you'll find it quite difficult.
>
> They are focused and intended for use by a power user.
>
>Jim.
>
>-----Original Message-----
>From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
>Salakhetdinov Shamil
>Sent: Saturday, January 23, 2016 08:22 AM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] MS Access Web Apps Javascript(?) Add-Ins - Was:Re[2]:
>Access and source control
>
> Hi Gustav --
>
>Thank your your reply. Yes, I also haven't had any new MS Access apps
>developed here for 10+ years.
>
>>>> Some ask for ”web solutions”
>It looks like using VS 2015 "dumb" MS Access Web Apps can be
>extended/enhanced by using Office365/SharePoint JavaScript(?) Add-ins by so
>making them real candidates for modern "web solutions" - here is a set of
>the links:
>
>Create add-ins for Access web apps
>From < https://msdn.microsoft.com/en-us/library/office/dn605890.aspx >
>Office 365: Bind and manipulate data in a SharePoint Access app
>From
>< https://code.msdn.microsoft.com/officeapps/Office-365-Bind-and-4876274e >
>Create JavaScript web apps using CORS to access Office 365 APIs
>From
><
https://msdn.microsoft.com/en-us/office/office365/howto/create-web-apps-usi
>ng-cors-to-access-files-in-office-365>
>See also:
>Set up an add-in catalog on SharePoint
>From < https://msdn.microsoft.com/en-us/library/office/fp123530.aspx > But
I
>must note that I haven't yet made any Add-Ins for MS Access Web Apps - I
>have tried by I have failed to follow MSDN work-through as my VS2015 setup
>seems to be missing Office Add-Ins templates, and I currently do not know
>where from to get them installed if that possible at all for VS 2015
>Professional edition.
>
>Thank you.
>
>-- Shamil
<<< skipped >>>
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list