Appendix B: What’s New in Access 2010
1265
Security
User-level security has been removed from Access (except when using the older .mdb file format)
in favor of the new trusted security model that relies on trusted folders and sandbox mode for any
other applications. The enhanced macro functionality is further designed to allow users the most
functionality through it. In a nutshell, the plan is to implement most or all your application’s logic
as the new embedded macro so that the application will be trusted and run under the new model.
This may prove difficult to implement in certain environments.For users who require user-level security, Access 2010 works with older-format .mdb files without
conversion or enabling. This means you can continue to use an Access 2000, 2002, or 2003 .mdb
file, complete with user-level security, in Access 2010 without changes.Access databases may now be password-protected with strong encryption. The password is not
stored within the database file (this feature applies only to the .accdb file format), and the pass-
word must be provided to Access when a user tries to open the database.Access database encryption is based on the Windows Cryptographic API.SharePoint
SharePoint Services are being used to provide functionality to enterprise applications over a
SharePoint Server for functionality such as revision history, permission setting, and recovery of
deleted records.SharePoint data residing on distant Web servers is available to local Access applications with no
special requirements other than a fast Internet connection. Access users (with the appropriate secu-
rity credentials) are able to view, update, and add to SharePoint data as if the data resided on their
desktop computer, no matter where the SharePoint server is hosted.Specifically prepared Access 2010 databases may be “published” to SharePoint 2010 sites. A Web-
enabled Access application contains only the forms, reports, controls, and other objects that are
compatible with SharePoint. Web-enabled Access applications can’t directly access data outside of
the SharePoint environment and are somewhat less capable than their desktop equivalents.Even so, the ability to build database applications in Access 2010 and make the applications avail-
able to authenticated SharePoint users, is a powerful and compelling feature of Access 2010.SharePoint is sure to grow in importance and prominence in environments where instant access to
remote data is a high priority.50_475348-bapp02.indd 126550_475348-bapp02.indd 1265 4/1/10 2:01 PM4/1/10 2:01 PM