Access web apps to be retired

It was announced this week that Access Services is going to be retired. Details of the announcement may be found here:  Updating the Access Services in SharePoint Roadmap Additional timeline information along with possible methods for exporting your data out of an Access web app may be found here: Access web apps no longer supported…

33

Access app: Restrict editing records by user

The following example demonstrates how to toggle the enabled property for the edit/delete action bar buttons on a form/view in relation to the current user.   Within SharePoint, create a new Access app In the Add Tables, search for and select the Orders template   Create a Data Macro to lookup the employee’s ID based…

7

Errors executing or saving data macro with SendEmail action in Access web app on SharePoint Online

Issue: You may encounter errors executing or saving data macros that use the SendEmail macro action in an Access web application on SharePoint Online. Errors: Invalid field name 'ID' Invalid object name 'Inserted' Cause: This is a product issue. Work Arounds: You may try any of the following options to work around the issue: 1. If the…

12

All action bar icons appearing on Popup form in Access apps

Issue: When using a custom theme in the SharePoint site that your Access app is located, you may encounter an issue where all action bar icons display within your popup form. Work Around: Navigate to the SharePoint site that contains your Access app (from within the Access app, click Back to Site). Select the Settings icon…

1

Unexpected autonumber jump in Access apps

We’ve received reports from customers that occasionally their Access app autonumber field jumps by an unexpected number. For example, you may have an ID field that is sequential from 1 to 83 but then the ID suddenly jumps to seemingly random number like 1075. The autonumber is meant to guarantee a unique record identifier larger…

5

Access Database Types Explained

Today’s post is in response to the frequent discussions we have with customers around the various types of Microsoft Access databases that you can create in Access and the key features that makes each of these unique. Access Desktop Database The desktop database has been around since Microsoft released the first version of Access and…

2

Access Web App error "We couldn't retrieve the items to list here"

We are receiving reports that many users are encountering an error "An error occurred. We couldn't retrieve the items to list here." when navigating views in their Access Web app on Office 365 (O365). The Access developers are aware of the problem, a fix has been made and is rolling out. Most tenants will be fixed this evening. A…

10

How to: Make external connections to an Access Web App

You may want to access the data stored in your Access Web app from other applications. An Access Web App stores its objects and data in a SQL Azure database for SharePoint Online instances or in a local SQL Server for SharePoint on-premise installations. In order to connect to the Access Web app data on…

19