What’s Been Removed from Microsoft Access 2010?
To start, the Microsoft Calendar control (mscal.ocx) has been completely removed from Access 2010. Microsoft suggests that users consider the Date Picker control as an alternative. In fact, Microsoft informs us that opening up an Access 2007 database that uses the Microsoft Calendar control in Access 2010 will generate an error message. In addition, the Calendar Control will not even appear in the database in this case. Users are advised to be prepared for the removal of the Calendar Control and deal with it prior to opening up an Access 2007 database in Access 2010.
The Microsoft Replication Conflict Viewer has been removed from Access 2010. However, an alternative property called the ReplicationConflictFunction is available. In fact, Microsoft is preempting problems associated with the removal of this feature with advice on how to create a custom procedure for resolving conflicts with synchronization.
As discussed in the first article in this series, native support for exporting data to PDF and XPS files has been added to Access 2010. This was in anticipation of removing the Snapshot file format available in previous versions of Access.
The option to export a report as a Snapshot file has been completely removed from Access 2010. However, many would agree that the ability to export to PDF and XPS files, both of which preserve layout and formatting settings, is a welcomed change.
Access 2007 did not allow the creation, modification, or importation of data access pages like previous versions of Access. However, data access pages continued to function in Access 2007. Access 2010 pushes data access pages further out of the picture by allowing you to open a database with data access pages but they will no longer function as they did in Access 2007.
When opening an Access 2007 database with data access pages, Access 2010 will return an error that they are no longer supported. Microsoft suggests creating a web database and publishing it to a SharePoint site through Access Services. This alternative may or may not work for some database and database applications so be sure to explore the removal of data access page support before you migrate to Access 2010.
Access 2007 supported linking, importing, and exporting using the Installable Index Sequential Access Method (IISAM) for Lotus1-2-3, Paradox, and Jet2.x. Access 2010 does not support this method.
Microsoft itself recommends that if you need this functionality in an Access database, to continue using Access 2007 or even an earlier version of Access. If you attempt to make a link, import, or export data using the IISAM, you will receive an error from Access 2010 and will be not able to continue the operation.