Access в SharePoint — помните о таком?

Для меня загадка — будет ли какое-то будущее у Access WebApps при таком количество ограничений и багов. Использовать как личную базу данных в общей среде — зачем? Использовать как общую базу данных но при этом плохо с безопасностью, нет возможности работать с Workflow? Зачем — не ясно

Хорошее резюме плюсов и минусов представлено в статье:

Pros of Access 2013 Web Apps

  • You can build them directly in Access 2013
  • They support relational data on multiple levels
  • No coding is required
  • The backend for them is SQL Server 2012, allowing for scalable data storage and access
  • Security is based on SharePoint groups; you can determine who has edit vs readonly access to the Access Web App through the standard SharePoint Visitors and Members groups
  • Microsoft offers data table templates, speeding the creation of Access Web Apps
  • The form designer tools have Microsoft Access’s trademark ease of use
  • You can package your app to sell on the Microsoft App Marketplace ($$$)

Cons of Access 2013 Web Apps

  • Records stored in Access Web Apps cannot trigger or be part of SharePoint 2013 workflows. If you want to build a SharePoint form that involves significant business processes, Access Web Apps might not be for you.
  • Security setup is basic and somewhat limited. First, it isn’t possible for users to own records. Second, there isn’t a way to separate who can add a record vs. who can edit a record. Third, there is no way to apply edit vs readonly permissions to specific tables in an app. If you can edit records in one table, you can edit records in all the tables within the app.
  • The app owns the database. Don’t expect Access Web Apps to provide a frontend to a centralized database that already exists.
  • For now, creating Access Web apps is a little buggy. When creating a very simple app, Access 2013 crashed on me twice, and I lost some work. Hopefully Microsoft will iron out the bugs in the coming Office 2013 service packs.

Работа с базой данных Access в Office 365 (SharePoint)

http://youtu.be/13-ckYp9ku0

Обратите внимание на требования:

  • Microsoft Office 365 for enterprises with Enterprise Services enabled;
  • Microsoft Access on a single client computer