Fixes or workarounds for recent issues in Access

I wanted to let everyone know of a new content page which highlights recent issues for Access. Going forward, we will utilize this page over the support blog for trending issues. Please check it out here: Fixes or workarounds for recent issues in Access You may also navigate to the site from https://support.office.com by locating the Troubleshooting section and…

0

“Reserved error (-7713)” in Access using linked ODBC tables

Issue: Historically when Access encountered a connection issue to an ODBC source, you would have to restart Access to reestablish the connection. An update was created to detect lost connections and reestablish them on next use and was released with the MSI update KB 3115501 in May 2017 and included with Office 365 builds starting…

3

SharePoint Access App scanner now available!

As customers discover the upcoming Access Apps retirement, some of the first questions are:    – Are we using Access Apps?   – How many Access Apps do we have?   – Where are these Access Apps?   With the recent release of the Access App scanner, you are now able to easily get inventory and usage…

0

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

Errors working with Access 2010 web databases on SharePoint Online

Issue: When attempting to open an Access 2010 web database within a SharePoint Online environment, you may receive one of the following error messages: “Site is down” Or “An error has occurred” Or “Failed to evaluate expression ‘<expression>’   Status/Resolution: The Product Group has reported that this issue should now be resolved for all tenants. In…

3

You may encounter errors with your ACCDE/MDE files and/or wizards after installing the March update for Office 2010 (KB3085515)

Issue: After installing the March public update for Office 2010, you may encounter problems with your Access 2010 database files. March 8, 2016, update for Office 2010 https://support.microsoft.com/en-us/kb/3085515 When attempting to launch the Access wizards, you may receive an error.  Examples: This feature isn't installed, or has been disabled. To install this feature, rerun the…

39

Attachment does not appear in Email generated from Access

Issue: Suppose you choose to export an object from Access to Email. When you preview the message in Outlook, the attachment does not appear in the attached line of the message. Cause: This problem occurs on a Microsoft Office 2016 Click-to-Run installation that has at least the December 11, 2015 update (version 16.0.6366.2036) installed. See KB 3132071 for more information and the current…

0

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

Access may encounter a crash after installing the November update KB2837592 or December update KB3114404

Issue: After installing the November or December public updates for Access 2010 or the Click-to-Run updates for Access 2013, Access may encounter a crash while performing a text file import/export. The crash occurs if you click on the Advanced button within the Import/Export wizard. November 10, 2015, update for Office 2010 (KB2837592) https://support.microsoft.com/en-us/kb/2837592 December 8,…

22

When switching from design view with multiple objects open, Access 2013 program hangs

Issue: When opening multiple objects in design view and then trying to switch to other views, Access may become unresponsive. This delay can last a few seconds up to a couple of minutes. Cause: This is a product issue. Work Arounds: You may try either of the following options to work around the issue: 1. Close…

0