Microsoft Access 2010 Bible

Chapter 35: Deploying Access Applications to SharePoint

1155

FIGURE 35.12

The Access application copied from SharePoint in edit mode

Note that the Access user interface includes a button to copy the changes you make to the applica-

tion back to SharePoint. Data changes are automatically reflected in SharePoint because all tables

are linked to SharePoint lists. You must explicitly submit your application changes, however, to

SharePoint before other users see them.

The technique described in this section provides a number of benefits to users and the application.

The data is protected by virtue of its existence as SharePoint lists. Users cannot access the data

unless they are authorized SharePoint users. Also, users must be granted access to the Shared

Documents library before they can open the stored Access application. (The Access application can

be stored in a different document library if a higher level of security is required. The Shared

Documents library is accessible to all SharePoint users by default.)

Furthermore, presumably the SharePoint site is managed and periodically backed up by system

administrators. No working .accdb file can be accidentally deleted or overwritten, and a single

copy of the data is shared by all users.