Office Access 2013 Web Apps

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

Office Access 2013 Web Apps

As of April, 2018, Access Web Apps will be shutdown on Office 365.

Read my story on this here.

 

So the rest of these Access Web App pages will be phased out of vb123.com.au later in 2017.

 

 

 

 

Here are a list of useful resources if you want to create a Web App in Office 365/SharePoint

 

Videos

201407Webapp

Garry has produced a series of videos so that you can decide if Access Web Apps are for you. These are from Garry's talk at the ShareThePoint conference in Sydney.
 
Garry's Access 2013 Web Apps on YouTube

The 2015 Microsoft MVP Virtual Conference talk on Access Web Apps

Jeff Conrad and Chris Usher talk at a SharePoint 2014

 

You Are Going To Need Books Like the Good Old Days

 

awabooks01_zoom30  



 
If you are an Access expert and think you know all there is to know about Access databases, its time for a cup of tea.  You need to start again, you need to understand the building blocks of a web app. You need to read /skim all of the Web Apps section of this book before you open start building databases.

If you are just starting, I would Read Jeff Conrad's book on Access Web Apps and keep a good eye on out for Andrew Couch's book Extend Microsoft Access Applications to the Cloud when it comes out (It will be good)

 

If you are a developer, Professional Access 2013 Programming is the book. The detail on sharepoint permissions, offsite reading/writing to databases seems very detailed.
 

How to Try It Out

 

Microsoft says "In order to try out Access 2013 Web Apps, be sure to choose one of the plans for business: Small Business or Enterprise." To find out more, go to this Microsoft page and look for the row "Access Services".

Ipad Access does not need a Tablet version of Office. See this YouTube video by Garry

In the meantime, Probably best that you sit back and watch a video from the SharePoint conference

Radi Atanassov says Access is Back

 

Whats New For Access 2013 Developers

 
This MS page will give you an idea of the new things in Access Web Apps

 

Filter Your Data with Access 2013

Learn how to add a filter to a View (used to be called a form) so that only some records are shown when you open a View.  This is done with queries. Because not all the old query tricks work, build up the complexity piece by piece.
 
and filter the data using a Popup Form

and How to: Filter a view by using a macro in an Access 2013 app  

 
 

Importing Data In Access Apps

When you import into an Access App, you cannot directly add to an existing table

The Difference Between Access 2010 Web Apps and Access 2013 Web Apps

Roger Carlson blogs about this topic here

 

Training Videos At Microsoft

Basics   Adding a filter data macro

 

If You Cannot Find The Web App after you have closed down Access 2013

Web apps are stored in .accdb files (that can only be opened in A 2013).  You may have trouble finding them, if so look for a hidden folder

C:\Users\<YourLoginName>\AppData\Local\Microsoft\Access\DatabaseCache\15.0

where YourLoginName is your windows login name.  You can move this accdb file around.

 

Where Did SQL Editor, Update, Delete and Append Queries Go

 

These are features that are not currently in the web apps 2013.  For now you will need to learn data macros or cleanup on the desktop and import and copy and paste.

If you are deleting data, you can select the records and press the delete button.  Unfortunately this doesn't apply to all the records you select.  Seems like about 200 rows maximum. If the Loading ... appears for a while, nothing is going to happen I think.

webapps01_zoom25
Figure 1 - Click to see erroneous Loading ... text

 

Using Excel With Web App Data

 

Excel Web App read-only article at Microsoft

 

Visual Studio + Java API for Office  Wall maps

http://msdn.microsoft.com/en-us/library/office/dn605904(v=office.15).aspx

The most important thing in the next link is Access is shown on the map :)

http://www.microsoft.com/en-us/download/details.aspx?id=42032

 

Try an Access Web App Without A Login/Pwd

 

The UK Access users group has an Access web app in their public web site here.  Click on Explore at the top of page to see the app

 

How Big Can The Access App Get

 

Search for Sharepoint App in this Microsoft Sharepoint page and there is discussions on this page Notes on Backup

 

Linking Tables

To Link to SQL Server in Azure, You will need to download SQL Server Native Client 11

 

Reviews of Access Web Apps
 
A couple of pertinent points and some insight into Web Apps

 

How to change regional timezones so you get the correct default date

 

Note: I am still having troubles with this but I am sure this worked for a while till I added my own domain to the SharePoint site

Open the Regional Time Zone Instruction File

or try this It is possible that your sharepoint site will not be in the correct time zone.