To be fair, most developers used Excel Pivots for their reporting and summary data outputs and this seems to be thinking here going forward as Microsoft Excel does provide richer tools and can connect to Access very easily indeed. This has now been dropped altogether as the components are no longer supported. Pivot Tables and Charts – This is a big decision for those who did adopt pivot tables and charts in the past. ACCDB file format with either versions 2007 or 2010 first.
This also includes any linked tables to this engine and will need to upgrade to the. How old can you be? With JET (the database engine for Access), version 3.x is now finished which means you will not be able to open an Access 97 (or earlier) database file. Most of the features will be replaced and you can quickly view the changes in Access 2013. In essence, it was a small version of SQL Server and now this has been dropped in favour of using the 2013 SQL Server database instead. So here we go, a list of the changes to Access 2013 from version 2010…Īccess database on the web – With the introduction of web creation services in Access 2010 using SharePoint 2010, you can still open and edit this version in 2013 but you will not be able to create any new databases and instead must use the 2013 SharePoint (or Office 365 variants) for either an SQL Server database or Azure SQL database.Īccess Database projects (ADP) – Ever used ADP? This was the way you scaled up to larger more robust database engines over and above JET. Don’t get me started on Windows 8! Microsoft Access Features And Functionality: What Has Been Discontinued Or Modified In Access 2013 Not all the features I will list below in this post have completely gone just been modified which is of course a good thing providing you are not too emotionally attached to the older style features of course.įor me, as seems to be the case for the vast majority of developers and users I’ve spoken to, that they feel the ugly ‘ flat’ look and feel is a step backwards making it look like an animated version with a slight hint of colour to a beta piece of software at pre-launch!īut Microsoft in their wisdom felt it needed freshening up with a more up to date version (albeit only three years) and we either stick with an earlier version or make the transition. Perhaps we should re-title this post as “Microsoft Access: Mind The Gaps!” Teaching and migrating to version 2013 has thrown up some Microsoft Access features which have since been dropped (or deprecated as we call it).
0 kommentar(er)
