[AccessD] Jet OLEDB provider - deprecated?

Haslett, Andrew andrew.haslett at ilc.gov.au
Wed Jul 2 18:57:43 CDT 2003


ditto on the slow update with XP.  PITA!

-----Original Message-----
From: MartyConnelly [mailto:martyconnelly at shaw.ca]
Sent: Thursday, 3 July 2003 9:20 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Jet OLEDB provider - deprecated?


MDAC 2.5 has Jet SP3; after that no Jet install with MDAC.

You must have SP3 installed to install follow up SP's, latest is SP 7.0 
just out this week.
They are cumulative patches; for example SP6 has patches for SP4 and SP5 
included

Jet 4.0 Service Pack 7 (SP7) Replication File Update - KB321076
http://www.microsoft.com/downloads/details.aspx?FamilyID=0185ceec-e3b2-4a3f-
8afd-e0cbf2b4a0bb&DisplayLang=en

Jet 4.0 Service Pack 7 (SP7) Full for all OS's
http://support.microsoft.com/?KBID=282010

winXP SP7.0 downloadable install rather than Windows update
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c1780c0-3f8f-4650-
b6ad-11badf3f4dab&DisplayLang=en

If you installed the Beta for SP 7.0 deinstall before installing 
approved SP7
You need SP7 installed before installing Refresh or Part2 of Beta 2 
Office 2003
Double-click Add/Remove Programs. In the list of currently installed 
programs,
select Windows 2000 Hotfix (SP4) Q816056 or Windows XP Hotfix (SP2) 
Q816056, and then remove
to deinstall Beta of SP 7.0

I found the WindowsUpdate site did a really slow install of SP7 (45 
minutes) for WinXP much quicker using
using the last url above for WinXP.

I found after this install, JRO.engine database conversion to higher 
version no longer works.
No great loss as you can still convert through DAO, just a problem if 
you only use VB6.0

Jim DeMarco wrote:

>Must be MDAC 2.7 then.
>
>Thanks,
>
>Jim DeMarco
>
>
>-----Original Message-----
>From: Gustav Brock [mailto:gustav at cactus.dk]
>Sent: Wednesday, July 02, 2003 10:29 AM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] Jet OLEDB provider - deprecated?
>
>
>Hi Jim
>
>Nope. Jet 4.0 is included in MDAC 2.6.
>Don't know about the "JRO components" though.
>
>/gustav
>
>
>  
>
>>I thought they removed Jet from MDAC but made it a separate download.
>>    
>>
>
>  
>
>>HTH,
>>    
>>
>
>  
>
>>Jim DeMarco
>>    
>>
>
>
>  
>
>>-----Original Message-----
>>From: Mike and Doris Manning [mailto:mikedorism at ntelos.net]
>>Sent: Wednesday, July 02, 2003 10:20 AM
>>To: 'Access Developers discussion and problem solving'
>>Subject: RE: [AccessD] Jet OLEDB provider - deprecated?
>>    
>>
>
>
>  
>
>>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
>>    
>>
>
>
>  
>
>>-----Original Message-----
>>From: accessd-bounces at databaseadvisors.com
>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brett Barabash
>>Sent: Wednesday, July 02, 2003 10:02 AM
>>To: 'accessd at databaseadvisors.com'
>>Subject: [AccessD] Jet OLEDB provider - deprecated?
>>    
>>
>
>
>  
>
>>While trying to solve an ADO-related problem, I ran across the following
>>page on MSDN:
>>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/ht
m/
>>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 at 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
>>    
>>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>***************************************************************************
********
>"This electronic message is intended to be for the use only of the named
recipient, and may contain information from Hudson Health Plan (HHP) that is
confidential or privileged.  If you are not the intended recipient, you are
hereby notified that any disclosure, copying, distribution or use of the
contents of this message is strictly prohibited.  If you have received this
message in error or are not the named recipient, please notify us
immediately, either by contacting the sender at the electronic mail address
noted above or calling HHP at (914) 631-1611. If you are not the intended
recipient, please do not forward this email to anyone, and delete and
destroy all copies of this message.  Thank You".
>***************************************************************************
********
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

IMPORTANT - PLEASE READ ******************** 
This email and any files transmitted with it are confidential and may 
contain information protected by law from disclosure. 
If you have received this message in error, please notify the sender 
immediately and delete this email from your system. 
No warranty is given that this email or files, if attached to this 
email, are free from computer viruses or other defects. They 
are provided on the basis the user assumes all responsibility for 
loss, damage or consequence resulting directly or indirectly from 
their use, whether caused by the negligence of the sender or not.


More information about the AccessD mailing list