Verify Jet SP

[Arno R]

I am planning to distribute a A2k app to one of my clients.
I know they have Office Pro SR1 installed on all their machines.
I think it might be a good idea to check their msjet40.dll version.

Tony Toews has code available to check the appropriate Jet sp pack, but for *what* should I check?
There are a LOT of msjet40.dll versions around...
Should I raise a warning if their version is < "4.0.8618.0" (this is my version here...)

Which jet-version is considered here as 'wrong' or 'least needed'?

Thanks,
Arno R

[Allen Browne]

The 8 in the first place of the minor version designates SP8 for JET 4, so
4.0.8xxx.x will do.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Arno R" <ar***********@tiscali.nl> wrote in message
news:43********************@dreader2.news.tiscali. nl...
I am planning to distribute a A2k app to one of my clients.
I know they have Office Pro SR1 installed on all their machines.
I think it might be a good idea to check their msjet40.dll version.

Tony Toews has code available to check the appropriate Jet sp pack, but for
*what* should I check?
There are a LOT of msjet40.dll versions around...
Should I raise a warning if their version is < "4.0.8618.0" (this is my
version here...)

Which jet-version is considered here as 'wrong' or 'least needed'?

Thanks,
Arno R

[Tom van Stiphout]

On Sat, 27 Aug 2005 21:45:15 +0800, "Allen Browne"
<Al*********@SeeSig.Invalid> wrote:

I find it safer to look for a specific number. This page has them all:
http://support.microsoft.com/default...b;en-us;239114

-Tom.

The 8 in the first place of the minor version designates SP8 for JET 4, so
4.0.8xxx.x will do.

[Arno R]

Thanks Tom and Allen,

Any idea which jet-sp-version my users really *need* to use a A2k db reliable ?

Would SP6 be sufficient?

Suppose there will be a SP9 in the coming month and I install that one.
I don't think it is necessary to immediately raise a warning if my users don't have the latest SP installed yet.

Also: Where can I find information about the fixes in each SP?

Thanks,
Arno R

"Tom van Stiphout" <no*************@cox.net> schreef in bericht news:lc********************************@4ax.com...

On Sat, 27 Aug 2005 21:45:15 +0800, "Allen Browne"
<Al*********@SeeSig.Invalid> wrote:

I find it safer to look for a specific number. This page has them all:
http://support.microsoft.com/default...b;en-us;239114

-Tom.

The 8 in the first place of the minor version designates SP8 for JET 4, so
4.0.8xxx.x will do.

[Allen Browne]

The article Tom referenced is the best info available. I doubt MS gives much
more detail than that.

Every service pack fixes bugs, so it is always important that the user gets
the latest one. From memory, if a Windows XP user gets SP2, that includes
Jet 4 SP8. SP7 would be an absolute minimum.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Arno R" <ar***********@tiscali.nl> wrote in message
news:43********************@dreader2.news.tiscali. nl...
Thanks Tom and Allen,

Any idea which jet-sp-version my users really *need* to use a A2k db
reliable ?

Would SP6 be sufficient?

Suppose there will be a SP9 in the coming month and I install that one.
I don't think it is necessary to immediately raise a warning if my users
don't have the latest SP installed yet.

Also: Where can I find information about the fixes in each SP?

Thanks,
Arno R

"Tom van Stiphout" <no*************@cox.net> schreef in bericht
news:lc********************************@4ax.com...

On Sat, 27 Aug 2005 21:45:15 +0800, "Allen Browne"
<Al*********@SeeSig.Invalid> wrote:

I find it safer to look for a specific number. This page has them all:
http://support.microsoft.com/default...b;en-us;239114

-Tom.

The 8 in the first place of the minor version designates SP8 for JET 4, so
4.0.8xxx.x will do.

[Tom van Stiphout]

On Sun, 28 Aug 2005 14:25:25 +0200, "Arno R"
<ar***********@tiscali.nl> wrote:

It's such an easy thing to install. Require the latest. Do a check at
startup time, and if not found, offer the user a hyperlink to install
from.

-Tom.

Thanks Tom and Allen,

Any idea which jet-sp-version my users really *need* to use a A2k db reliable ?

Would SP6 be sufficient?

Suppose there will be a SP9 in the coming month and I install that one.
I don't think it is necessary to immediately raise a warning if my users don't have the latest SP installed yet.

Also: Where can I find information about the fixes in each SP?

Thanks,
Arno R

"Tom van Stiphout" <no*************@cox.net> schreef in bericht news:lc********************************@4ax.com...

On Sat, 27 Aug 2005 21:45:15 +0800, "Allen Browne"
<Al*********@SeeSig.Invalid> wrote:

I find it safer to look for a specific number. This page has them all:
http://support.microsoft.com/default...b;en-us;239114

-Tom.

The 8 in the first place of the minor version designates SP8 for JET 4, so
4.0.8xxx.x will do.

[Arno R]

"Tom van Stiphout" <no*************@cox.net> schreef in bericht news:po********************************@4ax.com...

On Sun, 28 Aug 2005 14:25:25 +0200, "Arno R"
<ar***********@tiscali.nl> wrote:

It's such an easy thing to install. Require the latest. Do a check at
startup time, and if not found, offer the user a hyperlink to install
from.

-Tom.

I would agree with you Tom and thanks for the follow-up, but the problem here is as follows:
This is a small welfare organization where the app will be running.
They lack in-house-system-admins, and they are instructed also to NOT install anything... (virus-threats and such)
Only one day each month a free-lance-sysadmin comes to the place to check the computers and to do maintenance tasks.
When there is a problem one day. the admin will come (when called) also. (but this will cost extra money...)

I guess you understand that I do not want the admin to be called when it is not necessary.
For that reason I can (or will) not require the latest SP, but only the most needed sp.
I think I will require SP7 for the reason Allen mentioned (Win XP sp2)

Arno R

[Tom van Stiphout]

On Sun, 28 Aug 2005 19:26:16 +0200, "Arno R"
<ar***********@tiscali.nl> wrote:

If the sysadmin runs Microsoft Update on each machine (a good idea
anyway; the virus-threads you mentioned is one of them), they will
automatically get the latest Jet service pack.
-Tom.

"Tom van Stiphout" <no*************@cox.net> schreef in bericht news:po********************************@4ax.com...

On Sun, 28 Aug 2005 14:25:25 +0200, "Arno R"
<ar***********@tiscali.nl> wrote:

It's such an easy thing to install. Require the latest. Do a check at
startup time, and if not found, offer the user a hyperlink to install
from.

-Tom.

I would agree with you Tom and thanks for the follow-up, but the problem here is as follows:
This is a small welfare organization where the app will be running.
They lack in-house-system-admins, and they are instructed also to NOT install anything... (virus-threats and such)
Only one day each month a free-lance-sysadmin comes to the place to check the computers and to do maintenance tasks.
When there is a problem one day. the admin will come (when called) also. (but this will cost extra money...)

I guess you understand that I do not want the admin to be called when it is not necessary.
For that reason I can (or will) not require the latest SP, but only the most needed sp.
I think I will require SP7 for the reason Allen mentioned (Win XP sp2)

Arno R

[David W. Fenton]

"Arno R" <ar***********@tiscali.nl> wrote in
news:43********************@dreader2.news.tiscali. nl:

"Tom van Stiphout" <no*************@cox.net> schreef in bericht
news:po********************************@4ax.com...

On Sun, 28 Aug 2005 14:25:25 +0200, "Arno R"
<ar***********@tiscali.nl> wrote:

It's such an easy thing to install. Require the latest. Do a
check at startup time, and if not found, offer the user a
hyperlink to install from.

I would agree with you Tom and thanks for the follow-up, but the
problem here is as follows: This is a small welfare organization
where the app will be running. They lack in-house-system-admins,
and they are instructed also to NOT install anything...
(virus-threats and such) Only one day each month a
free-lance-sysadmin comes to the place to check the computers and
to do maintenance tasks. When there is a problem one day. the
admin will come (when called) also. (but this will cost extra
money...)

I guess you understand that I do not want the admin to be called
when it is not necessary. For that reason I can (or will) not
require the latest SP, but only the most needed sp. I think I will
require SP7 for the reason Allen mentioned (Win XP sp2)

SP7 is the worst possible choice. SP8 was the bug fix for all the
problems it introduced.

SP6 is the minimum required for reliability.

SP7/8 were simply security patches, and if you're not concerned
about the executation of arbitrary code by the Access expression
service (and I don't think you should be), then you don't need what
they offer.

However, SP8 doesn't hurt.

But I'd require only SP6 as the minimum.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Arno R]

"David W. Fenton" <dX********@bway.net.invalid> schreef in bericht news:Xn**********************************@216.196. 97.142...

SP7 is the worst possible choice. SP8 was the bug fix for all the
problems it introduced.

SP6 is the minimum required for reliability.

SP7/8 were simply security patches, and if you're not concerned
about the executation of arbitrary code by the Access expression
service (and I don't think you should be), then you don't need what
they offer.

However, SP8 doesn't hurt.

But I'd require only SP6 as the minimum.

Hmmm... If SP7 is such a bad choice then I need to do the following :
If SP6 then it's OK
If they have SP7 then they must be pressed to install SP8 ...

Thanks to all.

Arno R