In my first runs with Access 2013, I encountered the first and major no can do - it would not open the famous Access 2000 vintage NWIND.MDB that I have used for years to introduce, demonstrate and train people. Documentation on the web gives even more no can do-es. So, take a seat, maybe a stiff drink and let's see what Access 2013 does not support any more.
Original documentation: http://technet.microsoft.com/en-us/library/cc178954.aspx
Access 2013 does not open or import the classic Access .mdb.
- Access 2010 and 2007 supported .mdb well - even those secured by Workgroup Security. And all previous Access versions would import older versions of Access database files. Not this one. You need to convert the .mdb to .accdb in Access 2010 or 2007.
- In Microsoft's words: "the Jet 3.x IISAM driver is no longer available." The last version of Jet 3.x was 3.6 that I encountered with Access 2003.
Access 2013 does not create web databases (.accdb stored on Sharepoint Server)
Well, that was a short life. Access 2010 introduced the idea of creating Access databases that could be deployed to Microsoft Sharepoint servers and interacted with using a web browser. Microsoft has abandoned that idea.
Access 2013 does not support .adp files
Access 2013 does not support PivotCharts and PivotTables natively
When I first saw PivotTables grafted into Access 2003, I was quite excited, having seen the success of PivotTables in Excel over several generations. Unfortunately, PivotTables didn't "fly" - they were sluggish in performance, they didn't behave or produce results like genuine Excel PivotTables did and I never used that feature. No loss.
Access 2013 does not support dBase .dbf files
This feature is not regretted except for nostalgia. When Access 1.0 was born, the Number One desktop database was Ashton Tate, later Borland dBase III and dBase IV. dBase was a veteran product famous from the era of dBase II on early CPM-80 computers (even Apple ][s) and ushered the age of relational or pseudo relational databases onto personal desktop use. From those birth days, dBase market share plunged as it failed to dominate and excel in Microsoft Windows (dBase was extra premium cost, Access was bundled free in the Office Pro Suite). Of course in those days, Access had to be able to import from .dbf files but dBase as a commonly used program disappeared years ago.
Access 2013 does not support Data Collection teamwork with Microsoft Outlook
In Access 2003 or earlier, Microsoft had the idea of having an Access database, then using Microsoft Outlook to send out the data entry form, the recipient would key in one record and respond by replying to the sender. The sender's Outlook would detect the response and working with Access, route the data into the Access database. A sweet idea of hop-skip-and-jump and not needing corporate IT support for this action. Except that not the world is dominated by the internet and people not using Outlook to send or respond. I took this for training and demo but did not see it used in production.
Access 2013 does not support Database Replication
In the time of Access 97, the PCs were generally standalone and disconnected. Web apps were not as common. As a hop-skip-and-jump idea, Microsoft designed quite a sophisticated replication system so that disconnected PCs could accept data entry and then the files could be exchanged and merged. The level of complexity in the idea and in the implementation defeated users.
Access 2013 does not support Source Code Control
Some corporates and third party vendors did use Microsoft Access for multi-person team programming. With the proliferation of different programming tools, .NET apps, web apps, it is likely that this feature may not be missed.
Access 2013 does not have an SQL Server Upsizing Wizard
Access 97 or earlier offered an SQL Server Upsizing Wizard to help people migrated tables and queries to Microsoft SQL Server. A good idea but of course the differences between Access and SQL Server are large enough to require quite a bit of enrichment of migration features. Very quickly, third party migration utilities outstripped this wizard in ability.
Access 2013 does not have a Package Deployment Wizard
Once people got used to Access as a productive, useful system, there were often requests to have a one button installer that could install Access runtime and place the Access datafiles on the client's PC. This request might still surface, the way forward is to simply install Access runtime separately, place the Access datafile and create shortcuts to run the system.