JET is an SQL database, developed my
Microsoft mostly for
Access, but is different from Access and can also be used without Access.
JET Blue vs JET Red
JET Blue and JET Red are two completely separate implementations of the JET API. Because they're maintained by different teams, they're feature set is set is different and they cannot be used interchangably.
JET Red is the engine that is used in
Access.
JET Blue is what formerly was known as
Extensible Storage Engine (ESE). It was originally developed as a prospective upgrade for engine in Microsoft Access, but was never as such.
Apparently, blue referred to the color of the flag of Israel while Red referred to the color of the flag of Russia.
| JET Red | JET Blue |
| File sharing | embedded in application |
| Best effort file recovery | Guaranteed recovery (Write ahead logging, snapshot isolation) |
| Interfaces: ODBC, OLE DB | Write your own C |
| Max DB size: 2 GiB | 8 TiB (4 KiB pages) or 16 TiB (8 KiB pages) |
JET Red
An (or the?) interface to JET Red is
DAO
By default, JET stores the files in
MDBs. It also supports
dBASE, Microsoft Fox Pro, Paradox,
Excel and
ODBC.
An alternative and successor to JET is
MSDE