Difference between Microsoft.Jet.OleDb and Microsoft.Ace.OleDb

by

It’s mainly a matter of history, effectively ACE has superceded JET:

Wikipedia answers your question in great detail.

The most relevant sections are:

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

In addition, ACE provides a 64-bit driver, so can be used on 64-bit machines, whereas JET cannot.

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.

As for the second part of your question, I recently installed Office 2010, and I had to download the ACE components separately. I got them from the link Microsoft Access Database Engine 2010 Redistributable. This is likely because I had installed a 32-bit version of Office under 64-bit Windows; in any case, the necessary files are easy to obtain from Microsoft.

More Related Contents:

  1. Why is my query not updateable?
  2. Prevent enabling of shift bypass – Access 2010
  3. UrlDownloadToFile in Access 2010 – Sub or Function not Defined
  4. How does one decompile and recompile a database application?
  5. How do you use version control with Access development?
  6. Microsoft Access condense multiple lines in a table
  7. Code to loop through all records in MS Access
  8. Bang Notation and Dot Notation in VBA and MS-Access
  9. How do I make a stored procedure in MS Access?
  10. How can I get table names from an MS Access Database?
  11. Syntax error in insert into statement – what’s the error?
  12. Is there any way to create multiple insert statements in a ms-access query?
  13. Microsoft Access DBEngine.OpenDatabase() breaks for Network-Paths – Error 3050
  14. Is it possible to create a recursive query in Access?
  15. VBA: Difference in two ways of declaring a new object? (Trying to understand why my solution works)
  16. What is the equivalent of Select Case in Access SQL?
  17. How do I access the selected rows in Access?
  18. Access 2007 – Left Join to a query returns #Error instead of Null
  19. Access query producing results like ROW_NUMBER() in T-SQL
  20. Pivot Query in MS Access
  21. insert query with sequential primary key
  22. How do I execute multiple SQL Statements in Access’ Query Editor?
  23. Achieving ROW_NUMBER / PARTITION BY in MS Access
  24. Setting up an MS-Access DB for multi-user access
  25. MS Access prepared statements
  26. Create sequential ID value based on the year that a record is added
  27. How can I modify a saved Microsoft Access 2007 or 2010 Import Specification?
  28. Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess
  29. How to add a menu item to the default right click context menu
  30. CONCAT equivalent in MS Access

Leave a Comment