Jet planes?

What's MS Jet?

Now that I've started using ADO I've seen this term a lot.
What does it mean?

[Jimbob]

Jet is the database engine used for Access Databses - so if you wnat to open an mdb/e file using ADO, you use the Jet provider.

So let's say I have an ADO connection and a couple of recordsets, and I load an Access DB into them, what do I use the Jet provider for? :confused:

[JHausmann]

Originally posted by Sc0rp
So let's say I have an ADO connection and a couple of recordsets, and I load an Access DB into them, what do I use the Jet provider for? :confused:

As a link between the ADO connection and your recordsets. Think of Jet like you would ODBC...

But how do I actually implement it? :(

[Clunietp]

YOU don't actually implement it, it is the layer that sits between the database file and DAO/OLEDB (ADO).

When you program using DAO or ADO with the Jet provider, you are already implementing it

Hold on, so when I do this:

DB.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\mydbfile.mdb"
RS.Open "RecordsetName", DB, adOpenForwardOnly, adLockReadOnly

It's actually using the Jet provider?

And do I have to include a reference to:
MSJRO.DLL -
Microsoft Jet and Replication Objects 2.5 Library?