Monday, November 26, 2012

What's New in Office 2013

The official Microsoft listing of changes in Office 2013 for Office users is here.

What's New information for Office developers is here. The new MS Access application model is set out here.

Features removed in MS Access 2013:

Access Data Projects (ADP) functionality has been removed
Access 2013 SQL-based databases will replace much of the benefit of ADPs. There are three possible mitigations for ADPs:

. Convert the ADP to an Access App solution.
. Convert the ADP to a linked Access Desktop Database.
. Convert the ADP to a full SQL-based solution.

Import objects into an ACCDE file and then create linked tables to the existing data by using an earlier version of Access.

Access support of Jet 3.x IISAM driver is no longer available
An Access 97 user can no longer open an Access 97 database in Access 2013. To upgrade, the user must open the file in Office 2010 or an earlier version, and then open it in Office 2013. ACCDB is the recommended format for desktop databases. Open the Access 97 database file in an earlier version of Access and convert it to a later version. Access 2013 supports Access 2000 and later versions through Access 2010.

PivotCharts and PivotTables are removed
There are no options to create PivotCharts and PivotTables in Access 2013. Office Web components are no longer supported. Better charting capabilities in Excel. Use enhanced PivotChart and PivotTable capabilities in Excel. Charts that are not PivotCharts and that use the MSGraph component are still available in Access 2013. Charts that are created by the Chart Wizard component are still supported.

dBASE support removed from Access

Access Data Collection
Cannot create new Data Collection forms. The data collection feature enabled creation of data collection forms and sending those forms as an e-mail message. When customers returned those e-mail messages, the data was processed and stored in an Access database. Access 2013 cannot create new forms. Access 2013 enables processing data collection forms that are created in earlier versions of Access.

Access 2003 toolbar and menus fully removed
You can no longer create Access 2003 toolbar and menus that display in Access 2013. Access 2003 toolbars and menus are displayed in Access 2007 and Access 2010 without the Ribbon. They will not display in Access 2013 but will appear in the Add-ins tab in Access 2013. Custom Ribbon commands are supported. Toolbars display in the Add-ins tab on the Ribbon. Custom Ribbon commands are also supported.

Access Replication Options fully removed
When opening a .mdb file in Access 2010 or older, the Replication Options displays in the Ribbon Database Tools tab. This option is removed from Access 2013

Access Source Code Control fully removed
The Source Code Control add-in lets Microsoft Visual SourceSafe or other source code control systems integrate to allow check-in/check-out of queries, forms, reports, macros, modules, and data. The Developer Source Code Control is not available as an add-in for Access 2013.

Access Three-State Workflow fully removed
The entry points for workflow are no longer available. In UI Macros the Workflow commands are not available. If you open an existing Access 2010 database that has UI Macros with StartNewWorkFlow or Workflow tasks, Access displays a warning.

Access Upsizing Wizard fully removed
The Upsizing Wizard allowed useers to scale up Access database tables to a new or existing Microsoft SQL Server database. This feature is removed for Access 2013