By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,995 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

mixed languages and JET sp8 ...

P: n/a
I have just set up a new laptop with XP (in German) and am running
MS-Access 2003 (in English).

I would like to open an existing database (that I built earlier) but
keep getting the message that JET 4.0 SP8 must be installed. I have
gone to the Microsoft site and downloaded this both in German and in
English.

I tried loading the English version of the SP but was told that the
update was incompatible with my language. Then I tried the German one
and was told that the SPs on my system were newer than the one I was
trying to install and so the installation was aborted.

I then tried to open my database and was told once again that I need to
install Jet 4.0 SP8.

Arrgghh ... what is happening here? How can I check exactly what is and
isn´t installed? I looked under ´installed programs´ (control pannel)
but couldn´t see anything there (i.e. lists of installed SPs) and I
tried looking in the registry but wasn´t sure where to look.

Any tips here would be gratefully received.

Regards,
Alan Searle.

Remove the xxx to send me an e-mail.
Jan 11 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
What EXACTLY is the message?

Go to Tools, Macro, Macro Security, and set Macro Security to Low.

Jet is part of Windows currently, and the service packs are
installed as part of Windows Update, like XP Service Pack 2.

(david)
"Alan Searle" <aj*******@xxxyahoo.com> wrote in message
news:dq**********@newsreader3.netcologne.de...
I have just set up a new laptop with XP (in German) and am running
MS-Access 2003 (in English).

I would like to open an existing database (that I built earlier) but keep
getting the message that JET 4.0 SP8 must be installed. I have gone to
the Microsoft site and downloaded this both in German and in English.

I tried loading the English version of the SP but was told that the update
was incompatible with my language. Then I tried the German one and was
told that the SPs on my system were newer than the one I was trying to
install and so the installation was aborted.

I then tried to open my database and was told once again that I need to
install Jet 4.0 SP8.

Arrgghh ... what is happening here? How can I check exactly what is and
isn´t installed? I looked under ´installed programs´ (control pannel)
but couldn´t see anything there (i.e. lists of installed SPs) and I tried
looking in the registry but wasn´t sure where to look.

Any tips here would be gratefully received.

Regards,
Alan Searle.

Remove the xxx to send me an e-mail.

Jan 12 '06 #2

P: n/a
On Wed, 11 Jan 2006 19:55:49 +0100, Alan Searle
<aj*******@xxxyahoo.com> wrote:

To find out your version of Jet, follow this article:
http://support.microsoft.com/default...b;en-us;239114

I'm curious what triggers that message about SP8. AFAIK Access does
not trigger it. Hit Ctrl+Break when you get it again. If it is your
application generating it, you may (if MDB) break into that line of
code.

-Tom.

I have just set up a new laptop with XP (in German) and am running
MS-Access 2003 (in English).

I would like to open an existing database (that I built earlier) but
keep getting the message that JET 4.0 SP8 must be installed. I have
gone to the Microsoft site and downloaded this both in German and in
English.

I tried loading the English version of the SP but was told that the
update was incompatible with my language. Then I tried the German one
and was told that the SPs on my system were newer than the one I was
trying to install and so the installation was aborted.

I then tried to open my database and was told once again that I need to
install Jet 4.0 SP8.

Arrgghh ... what is happening here? How can I check exactly what is and
isnt installed? I looked under installed programs (control pannel)
but couldnt see anything there (i.e. lists of installed SPs) and I
tried looking in the registry but wasnt sure where to look.

Any tips here would be gratefully received.

Regards,
Alan Searle.

Remove the xxx to send me an e-mail.


Jan 12 '06 #3

P: n/a

Thanks for your help on my problem with Jet SP8. The full message that
I get is at the end of this posting.

And when I try to install SP8 (WindowsXP-KB829558-x86-DEU.exe, on a
German version of XP), I get the following message:

The Service Pack version of this system is newer than the Update that
you want to install.
The update does not need to be installed.

I then went on to check the version of jet and so located the DLL:

C:\windows\system32\Msjet40.dll

In 'properties', I found that the version is: 4.00.8618.0 ... which
corresponds to 'Security Bulletin MS04-014'. Which seems to be a later
release than SP8 (version 4.0.8015.0).

I am therefore a bit confused that my system says that I should update
to SP8 when I am already running an new version of Jet.

Yes, I can set the macro security to 'low' which switches off the
warning message but doesn't solve the problem.

My OS is XP Home with all updates installed (including XP SP2).

Any tips would be a great help.

Regards,
Alan Searle

PS: The full text of the message that I get is ...

Microsoft Jet 4.0 Service Pack 8 or later must be installed to block
unsafe expressions without affecting common functionality.
The latest Microsoft Jet 4.0 service pack is available from Windows Update.
To block unsafe expressions, see the About Microsoft Jet Expression
Service sandbox mode Help topic, which is available from the link at the
bottom of this topic.

What EXACTLY is the message?

Go to Tools, Macro, Macro Security, and set Macro Security to Low.

Jet is part of Windows currently, and the service packs are
installed as part of Windows Update, like XP Service Pack 2.

(david)
"Alan Searle" <aj*******@xxxyahoo.com> wrote in message
news:dq**********@newsreader3.netcologne.de...
I have just set up a new laptop with XP (in German) and am running
MS-Access 2003 (in English).

I would like to open an existing database (that I built earlier) but keep
getting the message that JET 4.0 SP8 must be installed. I have gone to
the Microsoft site and downloaded this both in German and in English.

I tried loading the English version of the SP but was told that the update
was incompatible with my language. Then I tried the German one and was
told that the SPs on my system were newer than the one I was trying to
install and so the installation was aborted.

I then tried to open my database and was told once again that I need to
install Jet 4.0 SP8.

Arrgghh ... what is happening here? How can I check exactly what is and
isn´t installed? I looked under ´installed programs´ (control pannel)
but couldn´t see anything there (i.e. lists of installed SPs) and I tried
looking in the registry but wasn´t sure where to look.

Any tips here would be gratefully received.

Regards,
Alan Searle.

Remove the xxx to send me an e-mail.


Jan 17 '06 #4

P: n/a

Thanks for your help on my problem with Jet SP8. The full message that
I get is at the end of this posting.

And when I try to install SP8 (WindowsXP-KB829558-x86-DEU.exe, on a
German version of XP), I get the following message:

The Service Pack version of this system is newer than the Update that
you want to install.
The update does not need to be installed.

I then went on to check the version of jet and so located the DLL:

C:\windows\system32\Msjet40.dll

In 'properties', I found that the version is: 4.00.8618.0 ... which
corresponds to 'Security Bulletin MS04-014'. Which seems to be a later
release than SP8 (version 4.0.8015.0).

I am therefore a bit confused that my system says that I should update
to SP8 when I am already running an new version of Jet.

Yes, I can set the macro security to 'low' which switches off the
warning message but doesn't solve the problem. The warning (to update
to SP8) comes when I try to set the security to 'medium'.

My OS is XP Home with all updates installed (including XP SP2).

Any tips would be a great help.

Regards,
Alan Searle

PS: The full text of the message that I get is ...

Microsoft Jet 4.0 Service Pack 8 or later must be installed to block
unsafe expressions without affecting common functionality.
The latest Microsoft Jet 4.0 service pack is available from Windows Update.
To block unsafe expressions, see the About Microsoft Jet Expression
Service sandbox mode Help topic, which is available from the link at the
bottom of this topic.
Tom van Stiphout schrieb:
On Wed, 11 Jan 2006 19:55:49 +0100, Alan Searle
<aj*******@xxxyahoo.com> wrote:

To find out your version of Jet, follow this article:
http://support.microsoft.com/default...b;en-us;239114

I'm curious what triggers that message about SP8. AFAIK Access does
not trigger it. Hit Ctrl+Break when you get it again. If it is your
application generating it, you may (if MDB) break into that line of
code.

-Tom.
I have just set up a new laptop with XP (in German) and am running
MS-Access 2003 (in English).

I would like to open an existing database (that I built earlier) but
keep getting the message that JET 4.0 SP8 must be installed. I have
gone to the Microsoft site and downloaded this both in German and in
English.

I tried loading the English version of the SP but was told that the
update was incompatible with my language. Then I tried the German one
and was told that the SPs on my system were newer than the one I was
trying to install and so the installation was aborted.

I then tried to open my database and was told once again that I need to
install Jet 4.0 SP8.

Arrgghh ... what is happening here? How can I check exactly what is and
isnt installed? I looked under installed programs (control pannel)
but couldnt see anything there (i.e. lists of installed SPs) and I
tried looking in the registry but wasnt sure where to look.

Any tips here would be gratefully received.

Regards,
Alan Searle.

Remove the xxx to send me an e-mail.


Jan 17 '06 #5

P: n/a
I see that several people have raised the same problem,
but no solutions are shown.

I don't have this problem myself. It looks like an
installation problem.

Check that no other copies of msjet40 are on your PC.

Try logging in as an Administrator.

use RegSvr32.exe to re-register DAO and ADO.

Uninstall and re-install Office.

Give PC to someone and get new PC...

sorry

(david)
"Alan Searle" <aj*******@xxxyahoo.com> wrote in message
news:dq**********@newsreader3.netcologne.de...

Thanks for your help on my problem with Jet SP8. The full message that I
get is at the end of this posting.

And when I try to install SP8 (WindowsXP-KB829558-x86-DEU.exe, on a German
version of XP), I get the following message:

The Service Pack version of this system is newer than the Update that you
want to install.
The update does not need to be installed.

I then went on to check the version of jet and so located the DLL:

C:\windows\system32\Msjet40.dll

In 'properties', I found that the version is: 4.00.8618.0 ... which
corresponds to 'Security Bulletin MS04-014'. Which seems to be a later
release than SP8 (version 4.0.8015.0).

I am therefore a bit confused that my system says that I should update to
SP8 when I am already running an new version of Jet.

Yes, I can set the macro security to 'low' which switches off the warning
message but doesn't solve the problem.

My OS is XP Home with all updates installed (including XP SP2).

Any tips would be a great help.

Regards,
Alan Searle

PS: The full text of the message that I get is ...

Microsoft Jet 4.0 Service Pack 8 or later must be installed to block
unsafe expressions without affecting common functionality.
The latest Microsoft Jet 4.0 service pack is available from Windows
Update.
To block unsafe expressions, see the About Microsoft Jet Expression
Service sandbox mode Help topic, which is available from the link at the
bottom of this topic.

What EXACTLY is the message?

Go to Tools, Macro, Macro Security, and set Macro Security to Low.

Jet is part of Windows currently, and the service packs are
installed as part of Windows Update, like XP Service Pack 2.

(david)
"Alan Searle" <aj*******@xxxyahoo.com> wrote in message
news:dq**********@newsreader3.netcologne.de...
I have just set up a new laptop with XP (in German) and am running
MS-Access 2003 (in English).

I would like to open an existing database (that I built earlier) but keep
getting the message that JET 4.0 SP8 must be installed. I have gone to
the Microsoft site and downloaded this both in German and in English.

I tried loading the English version of the SP but was told that the
update was incompatible with my language. Then I tried the German one
and was told that the SPs on my system were newer than the one I was
trying to install and so the installation was aborted.

I then tried to open my database and was told once again that I need to
install Jet 4.0 SP8.

Arrgghh ... what is happening here? How can I check exactly what is and
isn´t installed? I looked under ´installed programs´ (control pannel)
but couldn´t see anything there (i.e. lists of installed SPs) and I
tried looking in the registry but wasn´t sure where to look.

Any tips here would be gratefully received.

Regards,
Alan Searle.

Remove the xxx to send me an e-mail.



Jan 17 '06 #6

P: 1
Hi Alan,

I am getting the same message, on an English version of Access 2003 and English Windows XP. (With Norwegian regional settings, though.)
I don't fully understand it either, but after reading the help page (there is a Help button on the Unsafe Expressions dialog) and the Microsoft bulleting on it (http://office.microsoft.com/en-us/as...446591033.aspx) I learned this "feature" is called Sandbox mode.
The (very confusing) message about Service Pack 8 means to say that you will need SP8 to perform many operations in Sandbox mode. It's not saying you don't have SP8 installed.
After answering "Yes" once to disable Unsafe Expressions, you will not be bothered anymore.

It is probably a recent Windows update that makes Access ask this question now. I don't understand why the dialogs about Unsafe Expressions and SP8 have to be so confusing. I don't know how to disable Sandbox mode again after answering Yes once, apart from setting the Macro Security to Low. I also don't know why I can't find more hits about this problem when I search on internet, maybe it is only in rare configurations that this message pops up? Anyway, after answering Yes to disable Unsafe Expressions and to enable Sandbox mode, and with SP8 installed, you should be able to use your databases as normal.
Mar 21 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.