A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Office » Setup, Installing & Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

MSACCESS 2003 Fails After SP2 Update



 
 
Thread Tools Display Modes
  #21  
Old November 6th, 2005, 12:33 PM
Jon Abbott
external usenet poster
 
Posts: n/a
Default MSACCESS 2003 Fails After SP2 Update

I'm pasting what they told me to do with the registry below:

Import the Jet registry key from a working computer. The following registry
key can be exported from a computer that is not exhibiting the problem (a
“good” computer) and imported to a computer that is exhibiting the
problem.
This will correct the issue. As always, great care should be taken when
working with the Windows registry, as some changes could render Windows
unusable. Both machines need to have the same OS and the “good” machine
should have Office 2003 SP2 installed and working properly (i.e. Access
launches normally). If a “good” computer does not currently exist, once
can
be created by installing Office 2003 from a CD, or another source other than
a user policy, and then patched to the SP2 level.

I'm more optimistic and hope a hotfix will be available shortly. They have
to get this problem solved because they're going to get hammered on it if
they don't. My history with them is hard to understand. Sometimes I get a
hotfix very easily and quickly; othertimes, I beg for one to solve a problem
that seriously affects me and I am totally ignored.

Michael


It's not come through, can you please post the reg key again (try plain text,
looks like you've pasted an HTML page).

If it's just a reg key, I can easily fix it. I suspect it's either missing
from the MSI or is not set to always install.

Jon

  #22  
Old November 7th, 2005, 09:45 AM
Michael
external usenet poster
 
Posts: n/a
Default MSACCESS 2003 Fails After SP2 Update

Jon:

Sorry about that. I didn't paste their entire message. The key is
HKLM\Software\Microsoft\Jet.

Michael
  #23  
Old November 7th, 2005, 07:48 PM
Jon Abbott
external usenet poster
 
Posts: n/a
Default MSACCESS 2003 Fails After SP2 Update

"=?Utf-8?B?TWljaGFlbA==?=" wrote:
Jon:

Sorry about that. I didn't paste their entire message. The key is
HKLM\Software\Microsoft\Jet.

Michael


This doesn't fix it for me, did it work for you? I checked the Jet reg keys
over the weekend and found nothing wrong with them.

From the debugging I did, I've pinned it down to the feature AccessFiles and am
currently checking through that, although it's proving tricky to pin it down to
the sub feature that's causing it. I suspect someone in MS has manually
changed something in the Advertising tables, which is conflicting - causing a
repair everytime the app is launch.

Jon

  #24  
Old November 7th, 2005, 10:55 PM
Michael
external usenet poster
 
Posts: n/a
Default MSACCESS 2003 Fails After SP2 Update

Jon:

Honestly, I did not try it because I've had other things that are currrently
keeping me busy. I went back to SP1 and am hoping that a SP2 hotfix will be
available shortly.

Unfortunately, I need a post-SP2 hotfix for Excel that was developed for me.
I may have to address the Access problem again myself if I need to use the
updated Excel in the near future.

Michael

"Jon Abbott" wrote:

"=?Utf-8?B?TWljaGFlbA==?=" wrote:
Jon:

Sorry about that. I didn't paste their entire message. The key is
HKLM\Software\Microsoft\Jet.

Michael


This doesn't fix it for me, did it work for you? I checked the Jet reg keys
over the weekend and found nothing wrong with them.

From the debugging I did, I've pinned it down to the feature AccessFiles and am
currently checking through that, although it's proving tricky to pin it down to
the sub feature that's causing it. I suspect someone in MS has manually
changed something in the Advertising tables, which is conflicting - causing a
repair everytime the app is launch.

Jon


  #25  
Old November 18th, 2005, 12:17 PM posted to microsoft.public.office.setup
external usenet poster
 
Posts: n/a
Default MSACCESS 2003 Fails After SP2 Update

Any news about this issue?

  #26  
Old November 18th, 2005, 04:21 PM posted to microsoft.public.office.setup
external usenet poster
 
Posts: n/a
Default MSACCESS 2003 Fails After SP2 Update

I have the fix from Microsoft, although you will need to create or modify your
own MST to resolve the issue. MS have no date for a fix to the MSI package
itself.

You need to all the following entries to the MST:

RegKey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Excel\win32
Type: STRING
Value: C:\Program Files\Microsoft Office\OFFICE11\msaexp30.dll


RegKey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Excel\win32old
Type: STRING
Value: C:\Windows\System32\msexcl40.dll



I implemented I slightly more elegant solution by doing an AppSearch for win32
and using this for the win32old value. I also made both keys part of the
component that msaexp30.dll resides in. If you're happy modifiying MSI/MST
tables through Orca etc, here's the changes:


AppSearch table (1 entry):

Property: JET4EXCEL
Signatu JetWin32Reg



RegLocator table (1 entry):

Signatu JetWin32Reg
Root: 2
Key: SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
Name: win32
Type: 2



Registry table (2 entries):

Registry: Access.SP2Fix1
Root: 2
Key: SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
Name: win32old
Value: [JET4EXCEL]
Component: Global_Access_Core

Registry: Access.SP2Fix2
Root: 2
Key: SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
Name: win32
Value: [#MSAEXP30.DLL]
Component: Global_Access_Core



Regards
Jon Abbott
Clarksons Plc

  #27  
Old November 18th, 2005, 05:27 PM posted to microsoft.public.office.setup
external usenet poster
 
Posts: n/a
Default MSACCESS 2003 Fails After SP2 Update

Still waiting for a hotfix to be issued. I think Microsoft believes that
since I submitted the problem, I'm the only person in the world who has
experienced it.

I've tried to convince them that there are going to by many organizations
affected.

Michael

"Rui Ricardo" wrote:

Any news about this issue?


  #28  
Old January 25th, 2006, 06:16 PM posted to microsoft.public.office.setup
external usenet poster
 
Posts: n/a
Default MSACCESS 2003 Fails After SP2 Update

To revive an old thread.

Since Microsoft is now sending letters out saying that we have to upgrade to
SP2 for "legal reasons", are there any updates to this issue, hotfixes,
anything?

The problem still exists.

We are unable to perform this upgrade, well we could hack it, but a machine
that has more working parts, or program that has more lines of code is prone
to more problems.

So if we have to upgrade for "legal reasons" it would be nice for a hotfix
to appear, or anything to make this upgrade work like it should.


Jon,
Are these entries applied to the patched PRO11.msi file? If so after adding
these entries can I then perform the upgrade on the client computers without
the upgrade asking me to locate the pro11.msi file (and not letting me pick
the pro11.msi file on the network)?

"Jon Abbott" wrote:

I have the fix from Microsoft, although you will need to create or modify your
own MST to resolve the issue. MS have no date for a fix to the MSI package
itself.

You need to all the following entries to the MST:

RegKey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Excel\win32
Type: STRING
Value: C:\Program Files\Microsoft Office\OFFICE11\msaexp30.dll


RegKey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Excel\win32old
Type: STRING
Value: C:\Windows\System32\msexcl40.dll



I implemented I slightly more elegant solution by doing an AppSearch for win32
and using this for the win32old value. I also made both keys part of the
component that msaexp30.dll resides in. If you're happy modifiying MSI/MST
tables through Orca etc, here's the changes:


AppSearch table (1 entry):

Property: JET4EXCEL
Signatu JetWin32Reg



RegLocator table (1 entry):

Signatu JetWin32Reg
Root: 2
Key: SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
Name: win32
Type: 2



Registry table (2 entries):

Registry: Access.SP2Fix1
Root: 2
Key: SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
Name: win32old
Value: [JET4EXCEL]
Component: Global_Access_Core

Registry: Access.SP2Fix2
Root: 2
Key: SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
Name: win32
Value: [#MSAEXP30.DLL]
Component: Global_Access_Core



Regards
Jon Abbott
Clarksons Plc


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot update Outlook 2003 update DinosaurGreener General Discussion 4 May 13th, 2005 10:11 PM
Installing cumulative update for OE 6 Vasilis Outlook Express 8 May 7th, 2005 02:01 AM
2003 update link when Source open Ausrobbo Worksheet Functions 0 January 17th, 2005 07:25 AM
After installing Windows XP SP2 , how do I open old Excel 2003 fil Mike D General Discussion 2 September 2nd, 2004 10:21 PM
Bug in Office Update for Office 2003 Installation AA Smith Setup, Installing & Configuration 1 September 1st, 2004 04:43 PM


All times are GMT +1. The time now is 04:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.