What's MS Jet?
Now that I've started using ADO I've seen this term a lot.
What does it mean?
Printable View
What's MS Jet?
Now that I've started using ADO I've seen this term a lot.
What does it mean?
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:
As a link between the ADO connection and your recordsets. Think of Jet like you would ODBC...Quote:
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:
But how do I actually implement it? :(
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?