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 Access Version 2003 2002 (XP) 2000 97 95 2.0 1.1 1.0
Version Number 11.0 10.0 9.0 8.0 7.0 2.0 1.1 1.0
Original Release Date 2003 Nov 2001 May 1999 Jun 1997 Jan 1995 Aug 1994 Apr 1993 May 1992 Nov
Latest Service Pack SP3 SP3 SP3 SR2 -- 2.5 -- --
Minimum RAM 128 MB 72 MB 16 MB 16 MB 8 MB 4 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 Access Developer's Toolkit 2.0 Access 1.1 Distribution Kit --
64-bit Version
Office 365 Installation
Database Formats and Security 2003 2002 2000 97 95 2.0 1.1 1.0
MDB Format 2003 2000 2000 97 2.0 2.0 1.1 1.0
Jet Database Engine (DAO) 4.0 4.0 4.0 3.5 3.0 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 2003 2002 2000 97 95 2.0 1.1 1.0
Access Basic Programming Language
VBA Programming Language (VBA)
Shared IDE with Visual Basic 6.0
Database Container 2003 2002 2000 97 95 2.0 1.1 1.0
Database Window
Windows XP Themes
Navigation Pane and Search
Tabbed Interface
Ribbons
Linked Tables 2003 2002 2000 97 95 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 2003 2002 2000 97 95 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 2003 2002 2000 97 95 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 2003 2002 2000 97 95 2.0 1.1 1.0
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

 


[Atrás]