Access™ 2007 VBA Programmer's Reference

Appendix A. Upgrading to Access 2007

This appendix is a compilation of data gleaned from a couple dozen papers, hours of testing with several versions of Access, and several years of experience—as well as information from other developers. It highlights some of the key considerations in making informed decisions and plans for converting to and working in mixed environments with Access 2007. It also provides some steps for embarking on a conversion process, and deals with concerns for special circumstances such as work group security or replication. It touches on some of the issues users face when converting from 2007 to earlier formats.

With the most dramatic addition of features and power in more than a decade, Access 2007 is designed to appeal to a wide spectrum of users and developers. The new user interface (UI) is more intuitive and can automate many of the tasks that previously either required programming or weren't practical to do. The new features empower users to easily gather and analyze data from multiple sources, including SQL Server, Excel, e-mail, and websites, and make it easier for developers to automate processes and to provide unprecedented flexibility for user-customized reports. It is now feasible to include attachments in the database, and the new file format (ACCDB) offers security through encryption of the data file. Those are just a few of the innovative features that will lure people to 2007.

What about the individuals, businesses, and enterprises that ...