Microsoft Jet Database Engine

Microsoft Jet是微軟針對檔案型資料庫所發展的資料庫引擎（Database Engine），它的適用資料來源種類相當多，像是Microsoft Access、Microsoft Excel、dBase等等檔案型資料來源都可以利用Microsoft Jet資料庫引擎來使用SQL指令存取。

目前的Jet引擎最新版本為4.0，並且未來在x64平台上將不再支援。

Jet DLLs

Jet version	Jet engine	DLL file name	MDB version
1.1	1.10.0001	MSAJT110.DLL	1.0 / 1.1
2.0 （comlyr）	2.00.0000	MSAJT200.DLL	1.0 / 1.1 / 2.0
2.5（accsvc）	2.50.1606	MSAJT200.DLL	1.0 / 1.1 / 2.0 / 3.0
2.5（VB4 16）	2.50.1606	MSAJT200.DLL	1.0 / 1.1 / 2.0 / 3.0
3.0	3.0.0.2118	MSJT3032.DLL	1.0 / 1.1 / 2.0 / 3.0
3.5		MSJET35.DLL	1.0 / 1.1 / 2.0 / 3.0
4.0 (SP8)	4.0.8015.0	MSOLEDBJET40.DLL	1.0 / 1.1 / 2.0 / 3.0 / 4.0
ACE 12	12.0.xxxx.xxxx	ACECORE.DLL	1.0 / 1.1 / 2.0 / 3.X / 4.0 / ACE
ACE 14	14.0.xxxx.xxxx	ACECORE.DLL	3.X / 4.0 / ACE
ACE 15	15.0.xxxx.xxxx	ACECORE.DLL	4.0 / ACE
ACE 16	16.0.xxxx.xxxx	ACEOLEDB.DLL	4.0 / ACE
Sources: http://support.microsoft.com/kb/178880/en （页面存档备份，存于互联网档案馆） http://support.microsoft.com/kb/282010/en （页面存档备份，存于互联网档案馆） http://support.microsoft.com/kb/239114/en （页面存档备份，存于互联网档案馆）

应用程序/版本	Jet version
Microsoft Access 1.0	1.0
Microsoft Access 1.1	1.1
Microsoft Access 2.0	2.0
Microsoft Access 2.0 Service Pack	2.5
Microsoft Access 95 / Excel 95	3.0
Microsoft Access 97 / Excel 97 / PowerPoint 97 / Word 97	3.5
Microsoft Access 2000	4.0 SP1
Microsoft Access 2002	^[1]
Microsoft Access 2003	^[2]
Microsoft Access 2007	ACE 12
Microsoft Access 2010	ACE 14
Microsoft Access 2013	ACE 15
Microsoft Access 2016	ACE 16
Visual Basic 3.0	1.1
Visual Basic Compatibility Layer	2.0
Visual Basic 4.0 16-bit	2.5
Visual Basic 4.0 32-bit	3.0
Visual Basic 5.0	3.5
Visual C++ 4.X	3.0
Visual C++ 5.0	3.5
Microsoft Project 4.1 / Project 95	3.0
Internet Information Server 3.0	3.5
SQL Server 7.0	4.0
Redistributable installers
Jet 3.51 web download	3.5+
MDAC 2.1	4.0 SP1
MDAC 2.5	4.0 SP3 to SP6+
Jet 4.0	4.0 SP3 to SP8
2007 Office System Driver （页面存档备份，存于互联网档案馆）	ACE 12
Microsoft Access Database Engine 2010 （页面存档备份，存于互联网档案馆）	ACE 14
Microsoft Access Database Engine 2016 （页面存档备份，存于互联网档案馆）	ACE 16
操作系统
Windows Me	4.0 SP3
Windows 2000	4.0 SP3
Windows XP	4.0 SP5+
Windows Server 2003	4.0 SP6+
Windows Vista	4.0 SP8+
Windows Server 2008	4.0 SP8+
Windows 7	4.0 SP8+
Sources: Microsoft Jet Database Engine Programmer's Guide - Introduction （页面存档备份，存于互联网档案馆） INFO: Identifying the Jet Database Engine Components （页面存档备份，存于互联网档案馆） Microsoft Data Access Components (MDAC) release history （页面存档备份，存于互联网档案馆） Release manifest for MDAC 2.1 (2.1.1.3711.11) (GA) （页面存档备份，存于互联网档案馆） INFO: MDAC Version 2.6 and Later Do Not Contain Jet or Desktop ODBC Drivers （页面存档备份，存于互联网档案馆） Release manifest for MDAC 2.5 Service Pack 3 (2.53.6200.2) （页面存档备份，存于互联网档案馆） Wrong Autonumber How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine （页面存档备份，存于互联网档案馆）

^ The Access 2002 setup program only updated system files on certain versions of Windows and to a certain level.
^ Access 2003 relied on the Jet engine component of the operating system for its data storage and query processing.

[1] The Access 2002 setup program only updated system files on certain versions of Windows and to a certain level.

[2] Access 2003 relied on the Jet engine component of the operating system for its data storage and query processing.

[1]

[2]

Microsoft Jet Database Engine

From Wikipedia, the free encyclopedia · View on Wikipedia