Microsoft Access Services on SharePoint 2010 Does Not Support Custom Workflows

Microsoft Access Services does not support adding workflows on Microsoft SharePoint lists that contain the data for tables visible in an Access Services database.

Microsoft Access Services lists do not support custom workflows created in Visual Studio and do not support adding new workflows through the SharePoint user interface.

If you attempt to open a Microsoft Access Services site with SharePoint Designer to create a workflow, you will receive the expected message "This web site has been configured to disallow ediding with SharePoint Designer." Working with an Access Services web site through SharePoint Designer is not supported.

Microsoft Access 2010 Data Macros can be used to add logic to events that occur in the Access Services tables, such as adding, updating, or deleting data. The Data Macros created in the Microsoft Access user interface are stored in SharePoint as Workflows when an Access database is published to Access Services.

 

SharePoint lists that are not published through Microsoft Access Services support workflows. You can link to those lists from a Microsoft Access database on a local machine. The workflows for non-Access Services lists must be created or added on SharePoint.

While you cannot open Microsoft Access Services databases with SharePoint Designer, you can still use SharePoint Designer to work with SharePoint lists that are not part of an Access Services database.

Refer to the following links to learn more about Data Macros in Access 2010:

Attaching Logic to Data Using Data Macros in Access 2010 Applications

Create a data macro

 

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.