Wednesday, March 30, 2011

Microsoft Access and its Versions

Microsoft Access is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is available with Microsoft Office Suite applications included in professional and higher editions. 

It was first released in 1992 for windows applications and its version is 1.0, it was then improved in compatibility and was again released in 1993 and included Access basic Programming Language with version 1.1. This version worked well initially but later on it caused data corruption with files more than 10MB. 

Microsoft Access Versions and their year of releases: 


Date
Version
Version
number
Jet version
Supported OS
Office suite version
1992
Access 1.1
1
1.1
Windows 3.0

1993
Access 2.0
2.0
2.0
Windows 3.1x
Office 4.3 Pro
1995
Access for Windows 95
7.0
3.0
Windows 95
Office 95 Professional
1997
Access 97
8.0
3.5
Windows 9xNT 3.51/4.0
Office 97 Professional and Developer
1999
Access 2000
9.0
4.0 SP1
Windows 9x, NT 4.0, 2000, XP
Office 2000 Professional, Premium and Developer
2001
Access 2002
10
4.0 SP1
Windows 98Me, 2000, XP
Office XP Professional and Developer
2003
Access 2003
11
4.0 SP1
Windows 2000, XP, XP Professional x64, Vista
Office 2003 Professional and Professional Enterprise
2007
Access 2007
12
12
Windows XP SP2, XP Professional x64, Vista
Office 2007 Professional, Professional Plus, Ultimate and Enterprise
2010
Access 2010
14
14
Windows XP SP3, Vista, Windows 7
Office 2010 Professional, Professional Academic and Professional Plus

Jet base Engine 3.0 and 3.5 that are used in Access 7.0 and in Microsoft Access 97 has severe issues that made it unusable with computers more than 1GB of memory. It was fixed post release of Access 97 version. 
One most important feature in transition of Microsoft Access from 97 to 200 version is it is not backward compatible with its earlier versions. All the above versions support Access 2000 format.

0 comments:

Post a Comment

Search This Blog

Followers

Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More