Jet 4.0 Service Pack 8

[Tina]

I am running Access 2003 under Windows 2000 Pro. I've
been repeatedly receiving error messages indicating that I
have to have Service Pack 8 for Jet 4.0 installed, but
when I download it from the Windows Update site, the error
messages continue.

When I went to the Access support pages, I found that
there is a different version of this service pack that
needs to be applied if running under Windows 2000. I
downloaded and installed that version. I still receive
the error messages.

Following the directions on one of the support pages, I
searched for msjet40.dll to verify which Service Pack I
had, after all was said and done. I discovered that I had
*three* versions of this file (including SP8) installed in
three different locations.

Could this file duplication be responsible for the
persistent error messages, and if so, to which directories
do I need to propagate this file? Do I need to move all
the files in the service pack? I haven't received any
indication that the service pack *didn't* install
correctly or completely, but Access refuses to recognize
the installation. Any suggestions would be most
appreciated. Thank you!

--Tina

 

[Arvin Meyer]

Try uninstalling or at least unregistering each version:

regsvr32.exe /u "C:\Path to each|msjet40.dll"

then delete the file. Now reinstall the correct version for your machine.
That may be 2 copies if you have more than one version of Access running on
your machine.

You will still get error messages until you accept sandboxing certain
"unsafe" expressions, or set security to Low. To avoid the error messages
and still not set your security to low, you need to certify your
applications. You can self certify your apps to run only on your own
machine. If you can certify your code with your own certificate server you
can distribute it within your own domain. Otherwise, you'll need to get a
public certificate from Thawte or Verisign.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Tina]

Arvin -

Thanks! I unregistered the SP's, reinstalled, and changed
the security level, and I'm in business - not an error
message in sight! Thanks for your help.

--Tina