35- Comparativa Versiones Access
Fuente Original: https://fmsinc.com/MicrosoftAccess/history/features.htm
|
Microsoft
Access Version |
2019 | 2016 | 2013 | 2010 | 2007 |
| Version Number | 17.0 | 16.0 | 15.0 | 14.0 | 12.0 |
| Original Release Date | Fall 2018 | 2015 Sept | 2013 Feb | 2010 Jul | 2007 Jan |
| Latest Service Pack | continuous | SP1 | SP2 | SP3 | |
| Minimum RAM |
32 Bit:
1GB 64 Bit: 2GB |
32 Bit:
1GB 64 Bit: 2GB |
256 MB | 256 MB | |
| Part of Microsoft Office |
 |
|
|
|
|
| Free Runtime Version |
|
|
|
|
|
| Runtime Version | Download | Download | Download | Download | |
| 64-bit Version |
|
|
|
|
 |
| Office 365 Installation |
|
|
|
|
|
| Database Formats and Security | 2019 | 2016 | 2013 | 2010 | 2007 |
| MDB Format | 2003 | 2003 | 2003 | 2003 | 2003 |
| Jet Database Engine (DAO) | ACE | ACE | ACE | ACE | ACE |
| Workgroup Security (MDB format) |
|
|
|
|
|
| ActiveX Data Objects (ADO) |
|
|
|
|
|
| Record Locking, Unicode Storage |
|
|
|
|
|
| Explicit Database Trust |
|
|
|
|
|
| Trusted Locations (Directories) |
|
|
|
|
|
| Access Data Projects (ADP) connected to SQL Server |
|
|
|
|
|
| ACCDB Format |
|
|
|
|
|
| Access Database Engine (ACE) |
16.0 Download |
14.0 |
14.0 Download |
12.0 | |
| Database Encryption (ACCDB) |
|
|
|
|
|
| Data Macros (ACCDB) |
|
|
|
|
|
| Sandboxed ACE |
|
|
|
|
|
| Access Web Apps (AWA) |
|
SharePoint
2013 SQL Server Office 365 |
SharePoint
2013 SQL Server |
SharePoint
2010 Lists |
|
| Programming | 2019 | 2016 | 2013 | 2010 | 2007 |
| Access Basic Programming Language |
|
|
|
|
|
| VBA Programming Language (VBA) |
|
|
|
|
|
| Shared IDE with Visual Basic 6.0 |
|
|
|
|
|
| Database Container | 2019 | 2016 | 2013 | 2010 | 2007 |
| Database Window |
|
|
|
|
|
| Windows XP Themes |
|
|
|
|
|
| Navigation Pane and Search |
|
|
|
|
|
| Tabbed Interface |
|
|
|
|
|
| Ribbons |
|
|
|
|
|
| Linked Tables | 2019 | 2016 | 2013 | 2010 | 2007 |
| dBase Tables |
|
|
|
|
|
| Lotus 1-2-3 Tables |
|
|
|
|
|
| Paradox Tables |
|
|
|
|
|
| Excel *.xlsx Format (ACCDB only) |
|
|
|
|
|
| Saved Import/Export Specifications |
|
|
|
|
|
| Salesforce and Dynamics 365 |
|
Update |
|
|
|
| Field Data Types | 2019 | 2016 | 2013 | 2010 | 2007 |
| Hyperlinks |
|
|
|
|
|
| Link to SharePoint Lists |
|
|
|
|
|
| Attachment Fields (ACCDB) |
|
|
|
|
|
| Multi-value Fields (ACCDB) |
|
|
|
|
|
| Memo Fields with History (ACCDB) |
|
|
|
|
|
| Memo Fields as HTML (ACCDB) |
|
|
|
|
|
| SQL Server BigInt |
|
|
|
|
|
| Features | 2019 | 2016 | 2013 | 2010 | 2007 |
| Command Bars |
|
|
|
|
|
| ActiveX Controls |
|
|
|
|
|
| Data Access Pages (DAP) |
|
|
|
|
|
| Pivot Charts / Pivot Tables |
|
|
|
|
|
| Smart Tags |
|
|
|
|
|
| Visual SourceSafe Integration |
|
|
|
|
|
| Upsizing Wizard |
|
|
|
|
|
| Package Solution Wizard |
|
|
|
|
|
| Form Conditional Formatting of Fields |
|
|
|
|
|
| Digital Signatures |
|
|
|
|
|
| Data Collection Emails |
|
|
|
|
|
| Report Output to PDF |
|
|
|
|
|
| Report View |
|
|
|
|
|
| Alternating Row Colors |
|
|
|
|
|
| Datasheet Totals |
|
|
|
|
|
| Datasheet Multi-Select Column Filtering |
|
|
|
|
|
| Simplified "Smart" Datasheet/Form Filtering |
|
|
|
|
|
| Form Navigation Caption |
|
|
|
|
|
| Form Buttons with Text and Image |
|
|
|
|
|
| Form Object Anchoring and Resizing |
|
|
|
|
|
| Date Picker |
|
|
|
|
|
| Web Browser Control |
|
|
|
|
|
| Image Control with Control Source |
|
|
|
|
|
| Split Forms |
|
|
|
|
|
| Navigation Forms |
|
|
|
|
|
| Windows Version | 2019 | 2016 | 2013 | 2010 | 2007 |
| Windows 10 |
|
|
|
|
|
| Windows 8.0/8.1 |
|
|
|
|
|
| Windows 7.0/SP1 |
|
|
|
|
|
| Windows Vista |
|
|
|
SP1 |
|
| Windows XP |
|
|
|
SP3 | SP2 |
| Windows 2000 |
|
|
|
|
|
| Windows 98 |
|
|
|
|
|
| Windows NT 4.0 |
|
|
|
|
|
| Windows NT 3.51 |
|
|
|
|
|
| Windows 95 |
|
|
|
|
|
| Windows 3.1 |
|
|
|
|
|
| Windows 3.0 |
|
|
|
|
|
| Microsoft AccessVersion | 2003 | 2002 (XP) | 2000 | 97 | 95 |
| Version Number | 11.0 | 10.0 | 9.0 | 8.0 | 7.0 |
| Original Release Date | 2003 Nov | 2001 May | 1999 Jun | 1997 Jan | 1995 Aug |
| Latest Service Pack | SP3 | SP3 | SP3 | SR2 | -- |
| Minimum RAM | 128 MB | 72 MB | 16 MB | 16 MB | 8 MB |
| Part of Microsoft Office |
|
|
|
|
|
| Free Runtime Version |
 |
|
|
|
|
| Runtime Version | Office Developer Edition 2003 | Office Developer Edition 2002 | Office Developer Edition 2000 | Office Developer Edition 97 | Access Developer's Toolkit 7.0 |
| 64-bit Version |
|
|
|
|
|
| Office 365 Installation |
|
|
|
|
|
| Database Formats and Security | 2003 | 2002 | 2000 | 97 | 95 |
| MDB Format | 2003 | 2000 | 2000 | 97 | 2.0 |
| Jet Database Engine (DAO) | 4.0 | 4.0 | 4.0 | 3.5 | 3.0 |
| Workgroup Security (MDB format) |
|
|
|
|
|
| ActiveX Data Objects (ADO) |
|
|
|
|
|
| Record Locking, Unicode Storage |
|
|
|
|
|
| Explicit Database Trust |
|
|
|
|
|
| Trusted Locations (Directories) |
|
|
|
|
|
| Access Data Projects (ADP) connected to SQL Server |
|
|
|
|
|
| ACCDB Format |
|
|
|
|
|
| Access Database Engine (ACE) |
|
|
|
|
|
| Database Encryption (ACCDB) |
|
|
|
|
|
| Data Macros (ACCDB) |
|
|
|
|
|
| Sandboxed ACE |
|
|
|
|
|
| Access Web Apps (AWA) |
|
|
|
|
|
| Programming | 2003 | 2002 | 2000 | 97 | 95 |
| Access Basic Programming Language |
|
|
|
|
|
| VBA Programming Language (VBA) |
|
|
|
|
|
| Shared IDE with Visual Basic 6.0 |
|
|
|
|
|
| Database Container | 2003 | 2002 | 2000 | 97 | 95 |
| Database Window |
|
|
|
|
|
| Windows XP Themes |
|
|
|
|
|
| Navigation Pane and Search |
|
|
|
|
|
| Tabbed Interface |
|
|
|
|
|
| Ribbons |
|
|
|
|
|
| Linked Tables | 2003 | 2002 | 2000 | 97 | 95 |
| dBase Tables |
|
|
|
|
|
| Lotus 1-2-3 Tables |
|
|
|
|
|
| Paradox Tables |
|
|
|
|
|
| Excel *.xlsx Format (ACCDB only) |
|
|
|
|
|
| Saved Import/Export Specifications |
|
|
|
|
|
| Salesforce and Dynamics 365 |
|
|
|
|
|
| Field Data Types | 2003 | 2002 | 2000 | 97 | 95 |
| Hyperlinks |
|
|
|
|
|
| Link to SharePoint Lists |
|
|
|
|
|
| Attachment Fields (ACCDB) |
|
|
|
|
|
| Multi-value Fields (ACCDB) |
|
|
|
|
|
| Memo Fields with History (ACCDB) |
|
|
|
|
|
| Memo Fields as HTML (ACCDB) |
|
|
|
|
|
| SQL Server BigInt |
|
|
|
|
|
| Features | 2003 | 2002 | 2000 | 97 | 95 |
| Command Bars |
|
|
|
|
|
| ActiveX Controls |
|
|
|
|
|
| Data Access Pages (DAP) |
|
|
|
|
|
| Pivot Charts / Pivot Tables |
|
|
|
|
|
| Smart Tags |
|
|
|
|
|
| Visual SourceSafe Integration |
|
|
|
|
|
| Upsizing Wizard |
|
|
|
|
|
| Package Solution Wizard |
|
|
|
|
|
| Form Conditional Formatting of Fields |
|
|
|
|
|
| Digital Signatures |
|
|
|
|
|
| Data Collection Emails |
|
|
|
|
|
| Report Output to PDF |
|
|
|
|
|
| Report View |
|
|
|
|
|
| Alternating Row Colors |
|
|
|
|
|
| Datasheet Totals |
|
|
|
|
|
| Datasheet Multi-Select Column Filtering |
|
|
|
|
|
| Simplified "Smart" Datasheet/Form Filtering |
|
|
|
|
|
| Form Navigation Caption |
|
|
|
|
|
| Form Buttons with Text and Image |
|
|
|
|
|
| Form Object Anchoring and Resizing |
|
|
|
|
|
| Date Picker |
|
|
|
|
|
| Web Browser Control |
|
|
|
|
|
| Image Control with Control Source |
|
|
|
|
|
| Split Forms |
|
|
|
|
|
| Navigation Forms |
|
|
|
|
|
| Windows Version | 2003 | 2002 | 2000 | 97 | 95 |
| Windows 10 | * | * | * |
|
|
| Windows 8.0/8.1 | * | * | * |
|
|
| Windows 7.0/SP1 |
|
* | * |
|
|
| Windows Vista |
|
* | * |
|
|
| Windows XP |
|
|
|
|
|
| Windows 2000 | SP3 |
|
|
|
|
| Windows 98 |
|
|
|
|
|
| Windows NT 4.0 |
|
SP6 | SP2 | SP2 |
|
| Windows NT 3.51 |
|
|
|
SP5 |
|
| Windows 95 |
|
|
|
|
|
| Windows 3.1 |
|
|
|
|
|
| Windows 3.0 |
|
|
|
|
|
* not explicitly supported, but functional
| Microsoft Access Version | 2.0 | 1.1 | 1.0 |
| Version Number | 2.0 | 1.1 | 1.0 |
| Original Release Date | 1994 Apr | 1993 May | 1992 Nov |
| Latest Service Pack | 2.5 | -- | -- |
| Minimum RAM | 4 MB | -- | -- |
| Part of Microsoft Office |
|
|
|
| Free Runtime Version |
|
|
|
| Runtime Version | Access Developer's Toolkit 2.0 | Access 1.1 Distribution Kit | -- |
| 64-bit Version |
|
|
|
| Office 365 Installation |
|
|
|
| Database Formats and Security | 2.0 | 1.1 | 1.0 |
| MDB Format | 2.0 | 1.1 | 1.0 |
| Jet Database Engine (DAO) | 2.0, 2.5 with SP | 1.1 | 1.0 |
| Workgroup Security (MDB format) |
|
|
|
| ActiveX Data Objects (ADO) |
|
|
|
| Record Locking, Unicode Storage |
|
|
|
| Explicit Database Trust |
|
|
|
| Trusted Locations (Directories) |
|
|
|
| Access Data Projects (ADP) connected to SQL Server |
|
|
|
| ACCDB Format |
|
|
|
| Access Database Engine (ACE) |
|
|
|
| Database Encryption (ACCDB) |
|
|
|
| Data Macros (ACCDB) |
|
|
|
| Sandboxed ACE |
|
|
|
| Access Web Apps (AWA) |
|
|
|
| Programming | 2.0 | 1.1 | 1.0 |
| Access Basic Programming Language |
|
|
|
| VBA Programming Language (VBA) |
|
|
|
| Shared IDE with Visual Basic 6.0 |
|
|
|
| Database Container | 2.0 | 1.1 | 1.0 |
| Database Window |
|
|
|
| Windows XP Themes |
|
|
|
| Navigation Pane and Search |
|
|
|
| Tabbed Interface |
|
|
|
| Ribbons |
|
|
|
| Linked Tables | 2.0 | 1.1 | 1.0 |
| dBase Tables |
|
|
|
| Lotus 1-2-3 Tables |
|
|
|
| Paradox Tables |
|
|
|
| Excel *.xlsx Format (ACCDB only) |
|
|
|
| Saved Import/Export Specifications |
|
|
|
| Salesforce and Dynamics 365 |
|
|
|
| Field Data Types | 2.0 | 1.1 | 1.0 |
| Hyperlinks |
|
|
|
| Link to SharePoint Lists |
|
|
|
| Attachment Fields (ACCDB) |
|
|
|
| Multi-value Fields (ACCDB) |
|
|
|
| Memo Fields with History (ACCDB) |
|
|
|
| Memo Fields as HTML (ACCDB) |
|
|
|
| SQL Server BigInt |
|
|
|
| Features | 2.0 | 1.1 | 1.0 |
| Command Bars |
|
|
|
| ActiveX Controls |
|
|
|
| Data Access Pages (DAP) |
|
|
|
| Pivot Charts / Pivot Tables |
|
|
|
| Smart Tags |
|
|
|
| Visual SourceSafe Integration |
|
|
|
| Upsizing Wizard |
|
|
|
| Package Solution Wizard |
|
|
|
| Form Conditional Formatting of Fields |
|
|
|
| Digital Signatures |
|
|
|
| Data Collection Emails |
|
|
|
| Report Output to PDF |
|
|
|
| Report View |
|
|
|
| Alternating Row Colors |
|
|
|
| Datasheet Totals |
|
|
|
| Datasheet Multi-Select Column Filtering |
|
|
|
| Simplified "Smart" Datasheet/Form Filtering |
|
|
|
| Form Navigation Caption |
|
|
|
| Form Buttons with Text and Image |
|
|
|
| Form Object Anchoring and Resizing |
|
|
|
| Date Picker |
|
|
|
| Web Browser Control |
|
|
|
| Image Control with Control Source |
|
|
|
| Split Forms |
|
|
|
| Navigation Forms |
|
|
|
| Windows Version | 2.0 | 1.1 | 1.0 |
| Windows 10 |
|
|
|
| Windows 8.0/8.1 |
|
|
|
| Windows 7.0/SP1 |
|
|
|
| Windows Vista |
|
|
|
| Windows XP |
|
|
|
| Windows 2000 |
|
|
|
| Windows 98 |
|
|
|
| Windows NT 4.0 |
|
|
|
| Windows NT 3.51 |
|
|
|
| Windows 95 |
|
|
|
| Windows 3.1 |
|
|
|
| Windows 3.0 |
|
|
|
