[AccessD] Info: Jet SP 8.0 is out

In so much as you might not have written a code workaround to get a 
problem corrected in a later SP, you will have a problem. For example: 
:After you compact and repair a database that includes a table that has 
an AutoNumber field, you notice that when you enter new data, the 
AutoNumber is a duplicate of an earlier AutoNumber. This is fixed by 
SP4. You won't see the error developing in SP8, but if your client is 
still on SP3 she will. Or for example SP7 gets around problems of 
importing paradox and dbase files. MS and Borland kissed and made up so 
it is was fixed in SP7.  To find the errors corrected by SPs you will 
have to find the KB associated with each SP. Ha Ha Ha .Giggle They keep 
switching them every six months.

. To apply SP 8 it goes with Win 2003, 2000 and XP otherwise use SP7 for 
lower OS.
To apply either you need at least SP3 installed. The SP's are cumulative 
so that SP7 has all the fixes of SP7 thru SP4. There is also a seperate 
SP for replication and SP7. SP 8 fixes Access/Oracle problems.

There is a list here to determine your SP level from Version number of 
msjet40.dll
How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 
Database Engine
http://support.microsoft.com/default.aspx?scid=kb;EN-US;239114

SP7 here
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q282010
Rocky Smolin - Beach Access Software wrote:

>Marty:
>
>Belated questions, maybe you know - if I install SP8 and send an app to a
>client who is on an earlier SP can this cause problems at the client site?
>
>Regards,
>
>Rocky Smolin
>Beach Access Software
>
>----- Original Message ----- 
>From: "MartyConnelly" <martyconnelly at shaw.ca>
>To: "Access Developers discussion and problem solving"
><accessd at databaseadvisors.com>
>Sent: Friday, October 24, 2003 1:04 PM
>Subject: [AccessD] Info: Jet SP 8.0 is out
>
>
>  
>
>>Went looking for version SP 7.0 of Jet and got redirected.to 8.0
>>
>>Information about Jet 4.0 Service Pack 8
>>http://support.microsoft.com/?kbid=829558
>>
>>How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0
>>Database Engine
>>http://support.microsoft.com/default.aspx?scid=kb;EN-US;239114#11
>>
>>To find what Jet Service Pack you are running
>>On the Start menu, click Search.
>>In the Search Results pane, click All files and folders under Search
>>Companion.
>>In the All or part of the file name box, type msjet40.dll, and then
>>click Search.
>>In the list of files, right-click the Msjet40.dll file that is located
>>in the Windows\System32 (or Windows\System) folder, and then click
>>Properties.
>>Click the Version tab, and then use the following table to determine the
>>current Jet 4.0 service pack level:
>>Msjet40.dll Version Jet 4.0 Service Pack Level
>>4.0.2927.4 Service Pack 3 (SP3)
>>4.0.3714.7 Service Pack 4 (SP4)
>>4.0.4431.1 or 4.0.4431.3 Service Pack 5 (SP5)
>>4.0.6218.0 Service Pack 6 (SP6)
>>4.0.6807.0 Service Pack 6 (SP6) shipped only with Windows Server 2003
>>4.0.7328.0 Service Pack 7 (SP7)
>>4.0.8015.0 Service Pack 8 (SP8)
>>
>>-- 
>>Marty Connelly
>>Victoria, B.C.
>>Canada
>>
>>
>>
>>_______________________________________________
>>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
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada