Jet SP8 Setup Error

G

Gareth Howe

I am running Access 2003 on Windows XP (Service Pack 2)
When I open a database, I get a message box that says I need to install Jet
4 Service Pack 8.
When I try to install the service pack, I get an error-
KB829558 Setup Error
Setup has detected that the Service Pack version of this system is newer
than the update you are applying.
There is no need to install this update.

What's going on???
Access says I need the service pack but the service pack says I dont!

Thanks in advance for any thoughts or suggestions.

Gareth
 
A

Allen Browne

SP2 probably already installed an up to date version.

Locate the file msjet40.dll, typically in windows\system32.
Right-click, and choose Properties.
On the version tab, you should see:
4.0.8xxx.0
where xxx can be different numbers, but if you see the 8, you already have
SP8.

You can disable these messages in Access by lowering your macro security
settings:
Tools | Macro | Security | Low.
 
G

Gareth Howe

The version is 4.0.8618.0

So, SP8 is installed- is there a way I can convince Access that it is
installed?

Cheers,
Gareth
 
A

Allen Browne

I'm not seeing the problem message.
Did you try lowering the Macro Security setting?

Have you installed SP1 for Office 2003? That should convince it that things
are up to date.
 
G

Gareth Howe

The message I'm getting 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 fromWindows 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.
If the service pack is not applied:
Wizards and builders may not start.
Switchboards created by Switchboard Manager will fail.
The RunCode macro action for calling a Visual Basic for Applications (VBA)
procedure will fail.
Event handlers that call VBA procedures will fail.
VBA procedures called from a property sheet or used in a SQL statement will
fail.
Filtering on a hyperlink field will fail.
Some VBA functions called from a property sheet or SQL statement will fail.

More information about this error message online.

However, I can't install SP8 because when I run the file I get this message:

KB829558 Setup Error
Setup has detected that the Service Pack version of this system is newer
than the update you are applying.
There is no need to install this update.


The version of msjet40.dll is 4.0.8618.0

Office 2003 Service Pack 1 is installed.


As far as I can see, there is no reason for Access to continue to prompt me
about this, but it continues to do so.

Any other ideas or thoughts I might try?

Cheers,
Gareth
 
Top