"Microsoft Jet 4.0 Service Pack 8 or later must be installed to block unsafe expressions...." ???

P

(PeteCresswell)

Rebuilt my system last week.

Since then, when I run Access 11, I get the following two dialogs:
=======================================================
"Security Warning: Unsafe expressions are not blocked.
Do you want to block unsafe expressions?"
=======================================================

(click "No")

=======================================================
"Security Warning: Unsafe expressions are not blocked.
To block unsafe expressions, Microsoft Jet 4.0 Service Pack 8 or later must be
installed.....""
"Microsoft Jet 4.0 Service Pack 8 or later must be installed to block unsafe
expressions without affecting common functionality."
=======================================================

Reading the second dialog, it sounded like the service pack can be D/L'd from
http://WindowsUpdate.com... but when I got there, first it won't talk to Mozilla
and then, when IE was pointed at it, there seemed tb no way to just download the
SP.

Only option seems tb windows auto updating.

But I already have that in place and it's been doing it's thing since
I rebuilt the system last week.

Actually, I have something that I have labeled as "Jet Service pack 4.0 for XP
(WindowsXP-KB829558-x86-ENU).exe left over from prior builds.

But when I try to execute it, it says
-------------------------------------------------------------
"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"
--------------------------------------------------------------

Indeed, the file's props dialog says "File version: 5.3.23.4" and that's a lot
less than 8....if, indeed, it refers to the SP level...


Bearing in mind that I already have "Windows Update" installed and running since
day 1 of the build, does anybody got a suggestion for my next move?
 
T

Todos Menos [MSFT]

MS handicapped MS Access

there are 2 million distinct excel macro viruses-- why doesn't excel
prompt people 3 times


_SERIOUSLY_

I call for MS to stfu and to make MS Access open source

until we get the power to fix these goddamn bugs-- MS can ****
themselves
since they're obviously not serious about the database market
 
S

Sylvain Lafontaine

There are many versions available on this page, are you sure that you have
downloaded the right one?
 
P

(PeteCresswell)

Per "Sylvain Lafontaine said:
There are many versions available on this page, are you sure that you have
downloaded the right one?
Click to expand...

I'm not sure what I had for *breakfast*.... -)

But I do recall at least trying to make sure I got the "XP" version.

If/when I can backtrack to the page, I'll give it another shot.
 
S

Sylvain Lafontaine

Maybe running the MDAC Utility Component Checker could give us some
information here. You will find this utility at the top of the MDAC
downloading page.

In your case, forget about the MDAC and try installing only the Jet 4.0
Service Pack 8 for Windows XP.

Do you have WinXP or WinXP-64 bit?
 
P

(PeteCresswell)

Per "Sylvain Lafontaine said:
Maybe running the MDAC Utility Component Checker could give us some
information here. You will find this utility at the top of the MDAC
downloading page.
Click to expand...

----------------------------------
ComponentChecker 2.0
The following product releases were matched:

MDAC 2.8 SP1 ON WINDOWS XP SP2

Would you like to re-run the query for a specific
product release?
---------------------------------

Details as saved XML file
-------------------------------
<closestversion ClosestReleaseMatches="
MDAC 2.8 SP1 ON WINDOWS XP SP2"><filedetails><group name="MDAC 2.8 SP1 ON
WINDOWS XP SP2" count="11"><file
xmlns="http://tempuri.org/CCFilestream_template.xsd" name="MSADCOR.DLL"
dir="%COMMONFILES%\system\msadc\" CoreFile="Yes">
<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0"
fileversion="2.81.1117.0"/>
<found xmlns="" Description="Microsoft Data Access - Remote Data
Services Data Control Resources" date="08/4/2004" fileVersion="2.81.1117.0
(xpsp_sp2_rtm.040803-2158)" size="16384" version="2.81.1117.0"/></file>
<file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="msadrh15.dll" dir="%COMMONFILES%\system\ado\" CoreFile="Yes">
<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0"
fileversion="2.81.1117.0"/>
<found xmlns="" Description="Microsoft Data Access - ActiveX Data
Objects Rowset Helper" date="08/4/2004" fileVersion="2.81.1117.0
(xpsp_sp2_rtm.040803-2158)" size="57344" version="2.81.1117.0"/></file>
<file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="MSDASC.DLL" dir="%COMMONFILES%\system\ole db\" CoreFile="Yes">
<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0"
fileversion="2.81.1117.0"/>
<found xmlns="" Description="Microsoft Data Access - OLE DB Service
Components Stub" date="08/4/2004" fileVersion="2.81.1117.0
(xpsp_sp2_rtm.040803-2158)" size="4096" version="2.81.1117.0"/></file>
<file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="MSDASQL.DLL" dir="%COMMONFILES%\system\ole db\" CoreFile="Yes">
<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0"
fileversion="2.81.1117.0"/>
<found xmlns="" Description="Microsoft Data Access - OLE DB Provider
for ODBC Drivers" date="08/4/2004" fileVersion="2.81.1117.0
(xpsp_sp2_rtm.040803-2158)" size="315392" version="2.81.1117.0"/></file>
<file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="MSDASQLR.DLL" dir="%COMMONFILES%\system\ole db\" CoreFile="Yes">
<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0"
fileversion="2.81.1117.0"/>
<found xmlns="" Description="Microsoft Data Access - OLE DB Provider
for ODBC Drivers Resources" date="08/4/2004" fileVersion="2.81.1117.0
(xpsp_sp2_rtm.040803-2158)" size="16384" version="2.81.1117.0"/></file>
<file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="OLEDB32.DLL" dir="%COMMONFILES%\system\ole db\" CoreFile="Yes">
<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0"
fileversion="2.81.1117.0"/>
<found xmlns="" Description="Microsoft Data Access - OLE DB Core
Services" date="08/4/2004" fileVersion="2.81.1117.0 (xpsp_sp2_rtm.040803-2158)"
size="487424" version="2.81.1117.0"/></file>
<file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="SQLOLEDB.DLL" dir="%COMMONFILES%\system\ole db\" CoreFile="Yes">
<release name="MDAC 2.8 SP1 on Windows XP SP2"
version="2000.85.1117.0" fileversion="8.0.1117.0"/>
<found xmlns="" Description="Microsoft OLE DB Provider for SQL
Server" date="08/4/2004" fileVersion="2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)" size="528384" version="2000.85.1117.0"/></file>
<file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="SQLSRV32.DLL" dir="%SYSTEMDIR%\" CoreFile="Yes">
<release name="MDAC 2.8 SP1 on Windows XP SP2"
version="2000.85.1117.0" fileversion="3.85.1117.0"/>
<found xmlns="" Description="Microsoft SQL Server ODBC Driver"
date="08/4/2004" fileVersion="2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)"
size="442368" version="2000.85.1117.0"/></file>
<file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="msdart.dll" dir="%SYSTEMDIR%" CoreFile="Yes">
<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0"
fileversion="2.81.1117.0"/>
<found xmlns="" Description="Microsoft Data Access - OLE DB Runtime
Routines" date="08/4/2004" fileVersion="2.81.1117.0 (xpsp_sp2_rtm.040803-2158)"
size="151552" version="2.81.1117.0"/></file>
<file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="msdaorar.dll" dir="%COMMONFILES%\system\ole db\" CoreFile="Yes">
<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0"
fileversion="2.81.1117.0"/>
<found xmlns="" Description="Microsoft Data Access - OLE DB Provider
for Oracle Resources" date="08/4/2004" fileVersion="2.81.1117.0
(xpsp_sp2_rtm.040803-2158)" size="16384" version="2.81.1117.0"/></file>
<file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="msorc32r.dll" dir="%SYSTEMDIR%\" CoreFile="Yes">
<release name="MDAC 2.8 SP1 on Windows XP SP2"
version="2.575.1117.0" fileversion="2.575.1117.0"/>
<found xmlns="" Description="Microsoft Data Access - ODBC Driver for
Oracle Resources" date="08/4/2004" fileVersion="2.575.1117.0
(xpsp_sp2_rtm.040803-2158)" size="20480" version="2.575.1117.0"/></file>
</group><group name="UNKNOWN" count="2"><file
xmlns="http://tempuri.org/CCFilestream_template.xsd" name="msado15.dll"
dir="%COMMONFILES%\system\ado\" CoreFile="Yes">
<found xmlns="" Description="Microsoft Data Access - ActiveX Data
Objects" date="12/26/2006" fileVersion="2.81.1128.0 (xpsp_sp2_gdr.061226-0034)"
size="536576" version="2.81.1128.0"/></file>
<file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="MSADOMD.DLL" dir="%COMMONFILES%\system\ado\" CoreFile="Yes">
<found xmlns="" Description="Microsoft Data Access - ActiveX Data
Objects (Multi-Dimensional)" date="12/26/2006" fileVersion="2.81.1128.0
(xpsp_sp2_gdr.061226-0034)" size="180224" version="2.81.1128.0"/></file>
</group></filedetails></closestversion>
-------------------------------

In your case, forget about the MDAC and try installing only the Jet 4.0
Service Pack 8 for Windows XP.
Click to expand...

Makes sense bc one would think that SP2 would include the JET service pack.

I did that again and now I'm getting:
-------------------------------------------
KB829558 Setup Error
Setup has detected that the Service Pack version of
this system is newer than the update your are applying.

There is no need to install this update.
 
D

David W. Fenton

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam
please)> wrote in
Looks like that we may have misinterpreted the signification of
the error message. Here's the probable right solution for you:
http://office.microsoft.com/en-us/access/HA011071331033.aspx

The error message containing a notice about the required
installation of Jet SP8 seems to me as very confusing.
Click to expand...

I doesn't have anything to do with Jet 4 SP8, as you can get the
message even when you've got Jet 4 SP8 (or higher) already
installed.
 
T

Todos Menos [MSFT]

yes. this error message is a SYMPTOM of how Microsoft has been
handicapping MS Access.

Excel is the real threat--- why don't we try prompting those
spreadsheet dorks THREE TIMES?

what the **** I want to know who designed this; who was the PM that
allowed this handicap to go out
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft Jet 4.0 Service Pack 8 1
Office Pro Access 2003 4
Access 2003 error "unsafe expressions" 5
Microsoft Jet 4.0 Service Packs - Service Pack 8 5
Security Question 0
Microsoft Jet 4.0 Service Pack 8 message in Access 2003 1
Just upgraded 2000 to 2003 and have an issue on opeing up database 2
Access 2003 Nag Screens 3

Top