What’s Changed in Microsoft Access 2010?
As mentioned in the previous article in this series, Access 2010 will share the same native file format as Access 2007. This means that we will likely refer to this file paradigm as the Access 2007/2010 file structure the same way we now discuss the Access 2002/2003 file structure. Consequently, most of the changes to Access 2010 from Access 2007 will be additional features rather than a paradigmatic change in storage, retrieval, or interfacing with data in the database.
The first question on most people’s minds when discussing migration is whether Access 2010 is backward compatible with Access 2007. The answer is yes but with a few caveats. Certainly, Access 2010 will have more features than Access 2007. Otherwise, there would be no reason for the release of another version of Access.
As can be expected, Access 2010 will introduce new features that are not compatible with Access 2007. For example, Access 2007 SP1 cannot open Access 2010 databases that take advantage of certain new features. However, Access 2007 SP2 will at least open the database and allow a limited amount of viewing and design of an Access 2010 database that uses these new features. Essentially, a bit of experimentation will likely be necessary to determine which features are backward compatible and which will require a complete migration to Access 2010.
One of the best features of Access 2007 over previous versions was the enhanced security initiatives introduced by Microsoft. Trusted locations allowed users to work with confidence that their databases were secure in designated folders. In addition, loading of Access 2007 databases with macros (and other code) disabled allowed users to work free from the dangers of viruses and other intrusions.
These security features have been further enhanced in Access 2010 with integration with Microsoft SharePoint Foundation 2010. With this feature integrated into the work process, you can keep track of revision histories, set access permissions, and even recover deleted data and information.
One useful new feature in Access 2010 is the addition of support for SQL Server 2008 data types. These new data types include: DATE, DATETIME2, DATETIMEOFFSET, TIME, GEOGRAPHY, GEOMETRY, and HIERARCHYID. However, the following SQL Server 2008 data types are not supported if the user is in Access 2010’s table or design mode: GEOGRAPHY, GEOMETRY, and HIERARCHYID.
Microsoft has already offered a workaround for this limitation that includes using SQL Server 2008 for designing and creating tables, views, and other areas where these data types need to be used. However, users can still use Access 2010 to design modules, forms, macros, and reports that refer to these three SQL Server 2008 data types.