Hi, i whant to know where can i download the latest Microsoft Jet 4.0 Database Engine servise pack for win7. The thingh is i am trying to connect to sql server from excel. The Jet35sp3.exe file contains an update of several DLL files that are included with Microsoft Access 97, Microsoft Office 97 Professional Edition, Microsoft. Microsoft Jet Database Engine 3.5.
The Microsoft OLE DB Provider for Jet and the Jet ODBC driver are available in 32-bit versions only. More Information. We do not provide a 64-bit version of the Microsoft OLE DB Provider for Jet. Additionally, we do not provide a 64-bit version of the Jet ODBC driver. If you use the Microsoft OLE DB Provider for Jet or the Jet ODBC driver to. As a replacement for the Jet OLEDB Provider in server-side applications. As a general word processing, spreadsheet or database management system -To be used as a way to create files. (You can use Microsoft Office or Office automation to create the files that Microsoft Office supports.). Aug 09, 2019 When I try to run Stickies v8.0 program, I get a message 'Unable to initialize DAO/Jet db engine'. Have tried several fixes, none seem to work. Oct 18, 2017 In other words, MDAC 2.6, 2.7, 2.8, and all future MDAC/WDAC releases do not contain Microsoft Jet, the Microsoft Jet OLE DB Provider, the ODBC Desktop Database Drivers, or Jet Data Access Objects (DAO).
Active2 years, 3 months ago
It has been a good number of years since I did some programming with Classic ASP and Microsoft Access where we used 'Microsoft.Jet.Oledb' driver to access and display the data.
I have been asked to do some work with accessing MS Excel data using 'Microsoft.Ace.Oledb'. I have found this to be part of the 'Microsoft Access 2010 Engine Redistributable' download.
I would like to know if 'Microsoft.Jet.OleDb' has replaced 'Microsoft.Ace.Oledb' driver and are essentially the same or are they completely different things?
Also, do you normally get the 'Microsoft.Ace.Oledb' driver when you buy MS Access 2010?
Kara4,2461010 gold badges4646 silver badges5353 bronze badges
RT88RT88
2 Answers
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.
dashdash76.2k44 gold badges4242 silver badges6666 bronze badges
The drivers are essentially the same when used for basic operations, and show notable difference with more complex stuff (unions, nested queries, etc).
Based on personal experience, ACE does not provide fully backward compatible results. It may open and read/write the previous .mdb format but there are changes in data type casting of exactly the same queries.
For example, when using UNION on TEXT fields, where JET used to return TEXT(255) result, ACE returns MEMO ?!
This can produce a lot of trouble in combination with BI or reporting tools like Crystal Reports.
Milan OparnicaMilan Oparnica
Not the answer you're looking for? Browse other questions tagged ms-accessms-officems-access-2010 or ask your own question.
From Microsoft: The Jet35sp3.exe file contains an update of several DLL files that are included with Microsoft Access 97, Microsoft Office 97 Professional Edition, Microsoft Visual Basic (version 5.0 or later), and other products that incorporate Jet 3.5x. Microsoft Jet database engine version 3.51 provides an improved Compact utility that combines Compact and Repair into a single process. Also, the updated version of the Jet database engine generates an error if it encounters a problem during the Compact process, and then creates the table, MSysCompactError, in the destination database.
What do you need to know about free software?
Microsoft Jet Ole Db 4.0 Provider
Explore Further
From Microsoft:Microsoft Jet Db Price
The Jet35sp3.exe file contains an update of several DLL files that are included with Microsoft Access 97, Microsoft Office 97 Professional Edition, Microsoft Visual Basic (version 5.0 or later), and other products that incorporate Jet 3.5x. Microsoft Jet database engine version 3.51 provides an improved Compact utility that combines Compact and Repair into a single process. Also, the updated version of the Jet database engine generates an error if it encounters a problem during the Compact process, and then creates the table, MSysCompactError, in the destination database.