Tuesday, 2 December 2003

History of the MS Jet Database Engine

Jet Engine: History.

I found this through searching for Jet Red after reading a link to MSDN posted to Raymond Chen's comments after I posed the question: Can 64-bit Windows run 16-bit Windows programs?

Jet Red is the internal Microsoft name for the Jet database engine used by Access. There is/was also Jet Blue, which was used as the database engine for Exchange 4.0 and 5.0. Exchange 5.5 and later use a SQL Server-derived database engine (called ESE97 by Exchange 5.5, ESENT by Windows 2000 Active Directory, and ESE98 by Exchange 2000 - I think ESE stands for Enterprise Storage Engine).

It appears that Jet Red isn't going to be ported to 64-bit Windows, so you'll have to find an alternative for your 64-bit applications (MS would suggest SQL Server or the SQL Server Desktop Engine, known as MSDE). Personally, I think there's still room for an in-process database engine which accesses a single file as a database, although it should be possible to build this from SQL Server components if MS is so inclined.

1 comment:

Phil Morris said...

Yes an interesting one this. If MS are hoping to penetrate the ETL market with SSIS and SQL Server 2005 they are doing themselves n favours by not supporting their own file formats.

3 hours spent banging head up the wall on this one - thanks for the info.