As one of the more flagrant instances of global synchronicity I've encountered would have it, the following discussion is currently unfolding on the databaseadvisors.com forum as we speak. Might be of some interest.
The thread is:
[AccessD] Jet OLEDB provider - deprecated?
Tune in:
http://www.databaseadvisors.com/lists.htm
............................................(from the forum)
While trying to solve an ADO-related problem, I ran across the following page on MSDN:
http://msdn.microsoft.com/library/de...us/ado270/htm/
ado_deprecated.asp
in which it says:
Jet and Replication Objects (JRO)
The Microsoft Jet OLE DB Provider and other related components were removed from MDAC 2.6. Microsoft has deprecated the Microsoft Jet Engine, and plans no new releases or service packs for this component. As a result, the Jet and Replication Objects (JRO) is being deprecated in this release and will not be available in any future MDAC releases.
Huh?
AFAIK, our machines have MDAC 2.6 installed, and I use Jet 4.0 as an OLEDB provider without any issues.
Am I in for a nasty surprise? I can understand the "no new releases or service packs", but what about the "removed from MDAC 2.6" part?
Brett Barabash, MCP
Tappe Construction, Co.
Eagan, MN
bbarabash@tappeconstruction.com
(651) 256-6831
"One thing a computer can do that most humans can't is be sealed up in a cardboard box and sit in a warehouse." -Jack Handey
.................................................. ...
Each MDAC install contains update/upgrade information which is added to the previous version. You may have MDAC 2.6 checked but the system is really using JET 4.0 from MDAC 2.5
Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com
.................................................. ......
I thought they removed Jet from MDAC but made it a separate download.
HTH,
Jim DeMarco
.................................................. .......
Jim,
Yeah that's right. From 2.4 (or was it 2.5?) on up, JET is now a separate download.
Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net
.................................................. ...............
Must be MDAC 2.7 then.
Thanks,
Jim DeMarco
.................................................. ................
Gustav,
Actually if you look back at Brett's original post, he has a link to the article I was thinking of. However I was still off<g>. MDAC 2.5 was the last release that contained the JET components. 2.6 did not have JET.
So, it is probably working because all of these machines are running Windows 2000, which by default would have a Jet 4.0 provider installed.
Good to know. Thanks for the info.
.................................................. ..........
Hi Jim
Nope. Jet 4.0 is included in MDAC 2.6. Don't know about the "JRO components" though.
/gustav
.................................................. ............
Best,
Bob