ms-access - Microsoft.Jet.OleDb 和 Microsoft.Ace.OleDb 之间的区别

Question

自从我使用经典 ASP 和 Microsoft Access 进行一些编程以来，我们使用“Microsoft.Jet.Oledb”驱动程序来 Access 和显示数据已经很多年了。

我被要求做一些使用“Microsoft.Ace.Oledb” Access MS Excel 数据的工作。我发现这是“Microsoft Access 2010 Engine Redistributable”下载的一部分。

我想知道“Microsoft.Jet.OleDb”是否已替换“Microsoft.Ace.Oledb”驱动程序并且本质上是相同的还是完全不同的东西？

此外，您在购买 MS Access 2010 时通常会获得“Microsoft.Ace.Oledb”驱动程序吗？

Answer 1

这主要是历史问题，实际上 ACE 已经取代了 JET:

Wikipedia answers your question非常详细。

最相关的部分是:

With version 2007 onwards, Access includes an Office-specific version of Jet, initially called the Office Access Connectivity Engine (ACE), but which is now called the Access Database Engine. This engine is fully backward-compatible with previous versions of the Jet engine, so it reads and writes (.mdb) files from earlier Access versions. It introduces a new default file format, (.accdb), that brings several improvements to Access, including complex data types such as multivalue fields, the attachment data type and history tracking in memo fields. It also brings security and encryption improvements and enables integration with Microsoft Windows SharePoint Services 3.0 and Microsoft Office Outlook 2007

此外，ACE提供了64位驱动程序，因此可以在64位机器上使用，而JET则不能。

The driver is not part of the Windows operating system, but is available as a redistributable.[11] Previously the Jet Database Engine was only 32-bit and did not run natively under 64-bit versions of Windows.

关于你问题的第二部分，我最近安装了Office 2010，我必须单独下载ACE组件。我从链接 Microsoft Access Database Engine 2010 Redistributable 得到它们。这可能是因为我在 64 位 Windows 下安装了 32 位版本的 Office；无论如何，必要的文件很容易从 Microsoft 获得。