Navigate Up
Sign In

A Short Review of MS Access, SharePoint, InfoPath (2013)

Item is currently unrated. Press SHIFT+ENTER to rate this item.1 star selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+ESCAPE to leave rating submit mode.2 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.3 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.4 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.5 stars selected. Press SHIFT+ENTER to submit. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.

 

Editor's note: Contributor Marcel Meth is an independent consultant in the Boston area, specializing in Microsoft SharePoint & Office related technologies. Follow him @marcelmeth

After the November 2012 SharePoint Conference in Las Vegas (#spc12) there were a number of blog posts and people saying that Access 2013 was great and would be replacing InfoPath. Marc Anderson and Ruven Gotz have short posts summarizing #SPC12 and touch on the subject of InfoPath and Access. I also spoke with several individuals shortly after #SPC12 and they were excited about Access 2013.

Since I rely heavily on InfoPath for much of what I do, I wanted to kick the tires and see what everyone was talking about. First, a few notes about SharePoint 2013 and Office 2013.

  • Microsoft should rename Access: If you have tried to bing the word Access, then you know that the search results are overwhelming, because the word "access" is used for so many other purposes.

  • Use the RTM version of Office 2013! I was performing my investigations by leveraging the Office 365 Beta and the Office Applications that come with it. Not much was working! After I uninstalled the Beta version of Office 2013 and Installed the RTM version everything seemed to work.

  • Windows 7 and IE 9.0: The drag & drop that is being touted as "manna from heaven" seems to work well with Firefox, Safari, Chrome, and IE 10, but it does not work with IE 9!

  • Non Microsoft browsers are still second class citizens (except for the drag & drop): Microsoft has finally done away with the Active X's for datasheet view (that is brilliant!) One can now see the newly minted datasheet view in many browsers. But I still find that one needs to be in IE to do a number of key manual opeartions. For example pasting numerous rows of data from a spreadsheet into the new sheet view works only in IE.

Access 2013

    Microsoft Access is touted as a non developer tool. I know a number of people who are on the business side and love Access. These people will like the renewed energy that Microsoft has applied to Access. One should note that conceptually this functionality existed in SharePoint 2010. Here is what I see that is new:
    +The new version works better: Although I haven't tested it fully, it seems that many more features that work on the Desktop version of Access, now work in the published Web Application which is hosted by SharePoint 2013.
    +The new version has fairly robust browser based forms: End users can now fill in data using forms that are rendered in the browser.
    +The published version that resides in SharePoint now uses its own SQL server tables. So the engine appears to be SQL Server, not a modified version of Access built for a server. This stands to be quite robust, but I imagine that some quirks will surface due to new model.
    The limitations are:
    - Access is pretty much its own application and does not integrate with SharePoint building blocks. For example, an Access table is not easy to integrate with a SharePoint workflow. Further, although Access forms now are visible in a browser, they are not nearly as rich as InfoPath forms. InfoPath forms cannot easily integrate with the Access tables. In order to integrate SharePoint features and Access, one needs to tie SharePoint list(s) to Access as data sources. This overcomplicates the model and one may very well run into synchronization issues.

In short, although I believe there will be some people who will be happy with newly minted Access, I do not think that Access will be able to replace InfoPath and Workflow technologies. I do agree that Microsoft does not seem to have put much energy into InfoPath. If they leave a vacuum in this space, then others may very well take over, for instance Nintex Forms.

Categories: SharePoint; SPF 2013; InfoPath

Comments

Marzipan

Connection to Web Databases

Do you know if you can connect to the Access 2013 web databases from SSIS or SSRS?

Posted 25-Jan-2013 by Marzipan
Frederic Forest

On Access 2103 Web App isolation

The thing that gets to me is that, for what I managed to find on the official Office blogs, Access 2013 Web Apps (will need an accronym for that soon!) are not really good team players. They seem to do a good job for single, self-contained tasks, but they interact very little other data source. More importantly they are: - Read-only with SharePoint Lists. - Can't access other Access 2013 Web App tables/querries! Long story short, anything table that may be used by more than one web DB has to be a SP list and cannot be modified from within the Access Web DB itself. Holy cow, talk about limitations! While Infopath didn't get much love this time around, SP lists + workflows + InfoPath will probably remain our main choice for our quick, lightweight tools. :-/

Posted 29-Jan-2013 by Frederic Forest
Erich

drag and drop

Just FYI...drag and drop with IE9 does indeed work.

Posted 29-Jan-2013 by Erich
Chris Grist

drag and drop

It does, you need Office 2013 installed for it to work in IE8/IE9 as it updates a DLL file.

Posted 25-Mar-2013 by Chris Grist
montre guess

montre guess

Divertissement. la précédente sur le sac guess pas cher marché boursier finissent par être eu outs vendent.Probablement l'ombre le plus innovateur ainsi que daim fera l'objet adoré de la saison.Emporio Armani Logo design Watch, jusqu'à présent,cher Une paire de soie chiffon doux produit,guess certaines personnes ont suffisamment de connaissances sur ce type de sac a main guess nuit pour temps de commencer à Astuce choisir appropriée guess sac nuit à une importante doit dans ce cas en conséquence.Aujourd'hui, ce boutiques toujours très excitantes et populaire encore en Italie avec la réputation sociale de haut et de la gloire, sac à main guess incarne la valeur a été considérée comme une vie quotidienne dans la jouissance particulière. Parce que le sac guess est responsable pour nous clients noir et marron.This est vrai concernant sélectionnée , du meilleur de ma connaissance. bagages et même tous les vagabonds de maintenir des repères temporels honorés ainsi que les faits avancés vogue par exemple. Mais il ya cependant un changement des montre guess bourses par rapport aux bacs peu comme catégorie sexuelle.Comme étant un mètre de fait, il ya beaucoup de façons de distinguer un sac guess solde authentique d'un artificiel. Je suis impatient de trouver le sac guess dans son magasin spécialisé à avoir un essai de celui-ci. Pan sacs guess, cargos, bottes et accessoires auront une certaine partie de cette couleur au printemps 2014, il sera très bien si vous aimez cette couleur.Vous impressionné bague guess par leurs excellentes représentations. Doudoune Moncler respire la confiance en soi, les coteuses à la mode, Or guess Extérieur en cuir avec des pages de signatures cognac / safran / Cognac,sacs guess fonctionner dans toutes sortes d'autres méthodes.Si vous voulez que les avantages d'attirer chaque œil, mais ne peut pas se permettre ces guess Soldes très cher alors vous pouvez aussi essayer d'être l'accroche-regard avec christian.D'abord ramasser le type qui convient le mieux à vos besoins actuels après qui vont de la sacoche guess pas cher, la forme et le motif. comme décrit dans Associated Press du nouveau-né, Patrick a passé près de 20 ans, Cela leur permet de passer moins de fonds qui, quand ils montre guess sont en mesure de conseiller très aucune sorte avec l'artiste sud-est et l'installateur. http://www.paris-guess.com/

Posted 17-Apr-2014 by montre guess

Notify me of comments to this article

E-mail:
   

Add Comment

Title:

 
Comment:
Email:

   


Name:

 
Url: