Comparativa distintas versiones access

Comparativa  Versiones  Access

 

Fuente Original:   http://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

[Atrás]