5 Updates fail with Error Code: 0x80070005 - Other updates install

I am running Windows XP Home Service Pack 3 and was keeping up to date with 
updates until about a month ago when Windows Update offered about 10 
different Security Updates on one day.

Now, after running Windows Update I keep getting the message that the 
following 5 updates have failed to install, even though other updates do 
install in the same run.

Security Update for Windows XP (KB975713)
Security Update for Windows XP (KB978037)
Security Update for Windows XP (KB975560)
Security Update for Windows XP (KB977914)
Security Update for Windows XP (KB978706)

All these updates fail with Error Code: 0x80070005 

I have noticed that none of these updates are ever downloaded automatically 
and all of them need to be downloaded first. All other updates that do 
install are automatically downloaded to my computer, if I check using the 
custom install option.

I have tried the following:
Install and run the Windows Genuine Advantage Diagnostic Tool
Checked the KBxxxxx.LOG files for problems
Install and run the latest Windows Genuine Advantage Notification Tool
(Which reports I have a genuine copy of Windows)
Run the Malicious Software Removal Tool (twice)
Install and Run Windows Defender (which reports no problems)
Run CHKDSK/F at startup.
Uninstall (almost) all Symantec/Norton Antivirus software - (the Live Update 
icon in the control panel won't uninstall.)
Checked that these updates have correctly installed on another XP-SP3 
computer (They have).
Stopped the update service and reregistered the dll mentioned in KB943144
Tried to install these updates separately, or just one at a time.

None of these have been successful. What else can I do? 

(Note: Migrating to Windows 7 is not an option for this computer.)
0
Utf
3/27/2010 11:07:02 PM
windowsupdate 1336 articles. 0 followers. Follow

6 Replies
1304 Views

Similar Articles

[PageSpeed] 29

0x80070005: Access Denied

Is this a sudden, new problem?

> I have tried the following...
> Uninstall (almost) all Symantec/Norton Antivirus software - (the Live
> Update icon in the control panel won't uninstall.)

Explain/Tell us more about this.

What anti-virus application or security suite is installed and is your
subscription current?  What anti-spyware applications (other than Defender)?
What third-party firewall (if any)?

Has a(another) Norton or McAfee application ever been installed on the
computer (e.g., a free-trial version that came preinstalled when you bought
it)?
-- 
~Robear Dyer (PA Bear)
MS MVP-IE, Mail, Security, Windows Client - since 2002


Huttite wrote:
> I am running Windows XP Home Service Pack 3 and was keeping up to date
> with
> updates until about a month ago when Windows Update offered about 10
> different Security Updates on one day.
>
> Now, after running Windows Update I keep getting the message that the
> following 5 updates have failed to install, even though other updates do
> install in the same run.
>
> Security Update for Windows XP (KB975713)
> Security Update for Windows XP (KB978037)
> Security Update for Windows XP (KB975560)
> Security Update for Windows XP (KB977914)
> Security Update for Windows XP (KB978706)
>
> All these updates fail with Error Code: 0x80070005
>
> I have noticed that none of these updates are ever downloaded
> automatically
> and all of them need to be downloaded first. All other updates that do
> install are automatically downloaded to my computer, if I check using the
> custom install option.
>
> I have tried the following:
> Install and run the Windows Genuine Advantage Diagnostic Tool
> Checked the KBxxxxx.LOG files for problems
> Install and run the latest Windows Genuine Advantage Notification Tool
> (Which reports I have a genuine copy of Windows)
> Run the Malicious Software Removal Tool (twice)
> Install and Run Windows Defender (which reports no problems)
> Run CHKDSK/F at startup.
> Uninstall (almost) all Symantec/Norton Antivirus software - (the Live
> Update
> icon in the control panel won't uninstall.)
> Checked that these updates have correctly installed on another XP-SP3
> computer (They have).
> Stopped the update service and reregistered the dll mentioned in KB943144
> Tried to install these updates separately, or just one at a time.
>
> None of these have been successful. What else can I do?
>
> (Note: Migrating to Windows 7 is not an option for this computer.)

0
PA
3/27/2010 11:25:59 PM
> 0x80070005: Access Denied
I sort of gathered that. When I Google searched, I found commentary around 
the error code suggested to me that access was being denied because something 
had stopped Update recognising I had a genuine version of windows.  

> Is this a sudden, new problem?
This is a new problem that had a sudden onset when I was offed these 5 
Security Updates as part of a batch of 10-12 updates that were issued in 
February 2010. The other updates all downloaded and installed. These 5 failed 
then and continue to fail, even though other updates released after them are 
downloaded and installed.

> > I have tried the following...
> > Uninstall (almost) all Symantec/Norton Antivirus software - (the Live
> > Update icon in the control panel won't uninstall.)
> Explain/Tell us more about this.
I purchased my computer in 2002 with Norton 2002 preinstalled. That ran 
successfully being kept up to date until around 2007 when my subscription ran 
out and I could no longer renew it without upgrading/paying for a new 
antivirus application.  (I have an aversion to pre-planned software 
obsolescence.) It would still run though on the expired subsription - 
apparently. Then in late 2009 I acquired a new computer and a copy of McAfee, 
so attempted to uninstall Norton 2002 as a first step installing McAfee. 
While it seemed to uninstall the base Norton software, other Norton (Live 
Update)/Symantic components were not uninstalled, and I only removed those 
yesterday. There is still a Norton Live Update icon in the control panel, 
even though I now appear to have no Norton/Symantic applications installed as 
Programs.  When I click the Icon it says that it is an "Applet" to control 
the setup of live update and gives a dialog box that allows me to adjust 
parameters like the check for updates frequency.

> What anti-virus application or security suite is installed and is your
> subscription current?  
I currently only have Microsoft Defender running. It was last updated 
successfully yesterday via Windows Update. It appears active and has detected 
changes made to the computer today (since posting the problem) while 
attempting to run  Microsoft Fix It 50202 - to see if resetting Windows 
Upgrade components will assist.

> What anti-spyware applications (other than Defender)?
I have had Lavasoft AdAware 2.5 installed. But the subscription has expired 
and rather than upgrade to the new version I installed Windows Defender.

> What third-party firewall (if any)?
I am using the Windows Firewall, only. No other firewall is installed.

> Has a(another) Norton or McAfee application ever been installed on the
> computer (e.g., a free-trial version that came preinstalled when you bought
> it)?
I am not aware of any other Norton or McAfee application being installed.  I 
may have run a McAfee installer from memory stick but stopped the 
installation when I realised that Norton needed to be removed first. (I 
cannot be certain as I may have run McAffee on another computer with Norton 
installed and realised I had to remove Norton before installing McAfee.) 

I realise that I am running a computer that is vulnerable to infection by 
malware. However, I have watched the processes running in Task Manager and 
checked out anything I thought suspicious. I have also checked System 
Information for running tasks/processes - which is how I discovered Live 
Update was still running. I have set the Security Settings of Internet 
Explorer to prompt me for pretty much everything a website might do in the 
Internet Zone, (some might think it annoying and that I am paranoid). and 
only have a few Trusted websites, like my bank and Microsoft Update. I have 
generally avoided installing software I don't know much about.  Though after 
I had problems with an application I downloaded, about a year ago, I went 
back and removed the downloaded file and checked my machine for possible 
infection by even checking the registry to ensure program keys and other 
references to the application were not present.  Nobody else uses my 
computer, so I don't think it is currently infected by malware - though I 
cannot be certain of that.

-- 
> ~Robear Dyer (PA Bear)
> MS MVP-IE, Mail, Security, Windows Client - since 2002
Thanks for your interest.
 
> Huttite wrote:
> > I am running Windows XP Home Service Pack 3 and was keeping up to date
> > with
> > updates until about a month ago when Windows Update offered about 10
> > different Security Updates on one day.
> >
> > Now, after running Windows Update I keep getting the message that the
> > following 5 updates have failed to install, even though other updates do
> > install in the same run.
> >
> > Security Update for Windows XP (KB975713)
> > Security Update for Windows XP (KB978037)
> > Security Update for Windows XP (KB975560)
> > Security Update for Windows XP (KB977914)
> > Security Update for Windows XP (KB978706)
> >
> > All these updates fail with Error Code: 0x80070005
> >
> > I have noticed that none of these updates are ever downloaded
> > automatically
> > and all of them need to be downloaded first. All other updates that do
> > install are automatically downloaded to my computer, if I check using the
> > custom install option.
> >
> > I have tried the following:
> > Install and run the Windows Genuine Advantage Diagnostic Tool
> > Checked the KBxxxxx.LOG files for problems
> > Install and run the latest Windows Genuine Advantage Notification Tool
> > (Which reports I have a genuine copy of Windows)
> > Run the Malicious Software Removal Tool (twice)
> > Install and Run Windows Defender (which reports no problems)
> > Run CHKDSK/F at startup.
> > Uninstall (almost) all Symantec/Norton Antivirus software - (the Live
> > Update
> > icon in the control panel won't uninstall.)
> > Checked that these updates have correctly installed on another XP-SP3
> > computer (They have).
> > Stopped the update service and reregistered the dll mentioned in KB943144
> > Tried to install these updates separately, or just one at a time.
> >
> > None of these have been successful. What else can I do?
> >
> > (Note: Migrating to Windows 7 is not an option for this computer.)
> 
> .
> 
0
Utf
3/28/2010 2:20:01 AM
Huttite


Oh my. You are sure loaded with unwanted Security especially the ones below

Use these uninstall tools from Symantec and then the one from MaCafee and then post 
back with result

Norton Removal Tool (Remove all Symantec listed products that is still installed)
http://service1.symantec.com/SUPPORT/tsgeninfo.nsf/docid/2005033108162039

McAfee Removal Tool
http://service.mcafee.com/FAQDocument.aspx?lc=1033&id=TS100507
-- 
Peter

Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.

"Huttite" <Huttite@discussions.microsoft.com> wrote in message 
news:01096B5D-FDAB-4946-A237-3504F88EEAA9@microsoft.com...
>> 0x80070005: Access Denied
> I sort of gathered that. When I Google searched, I found commentary around
> the error code suggested to me that access was being denied because something
> had stopped Update recognising I had a genuine version of windows.
>
>> Is this a sudden, new problem?
> This is a new problem that had a sudden onset when I was offed these 5
> Security Updates as part of a batch of 10-12 updates that were issued in
> February 2010. The other updates all downloaded and installed. These 5 failed
> then and continue to fail, even though other updates released after them are
> downloaded and installed.
>
>> > I have tried the following...
>> > Uninstall (almost) all Symantec/Norton Antivirus software - (the Live
>> > Update icon in the control panel won't uninstall.)
>> Explain/Tell us more about this.
> I purchased my computer in 2002 with Norton 2002 preinstalled. That ran
> successfully being kept up to date until around 2007 when my subscription ran
> out and I could no longer renew it without upgrading/paying for a new
> antivirus application.  (I have an aversion to pre-planned software
> obsolescence.) It would still run though on the expired subsription -
> apparently. Then in late 2009 I acquired a new computer and a copy of McAfee,
> so attempted to uninstall Norton 2002 as a first step installing McAfee.
> While it seemed to uninstall the base Norton software, other Norton (Live
> Update)/Symantic components were not uninstalled, and I only removed those
> yesterday. There is still a Norton Live Update icon in the control panel,
> even though I now appear to have no Norton/Symantic applications installed as
> Programs.  When I click the Icon it says that it is an "Applet" to control
> the setup of live update and gives a dialog box that allows me to adjust
> parameters like the check for updates frequency.
>
>> What anti-virus application or security suite is installed and is your
>> subscription current?
> I currently only have Microsoft Defender running. It was last updated
> successfully yesterday via Windows Update. It appears active and has detected
> changes made to the computer today (since posting the problem) while
> attempting to run  Microsoft Fix It 50202 - to see if resetting Windows
> Upgrade components will assist.
>
>> What anti-spyware applications (other than Defender)?
> I have had Lavasoft AdAware 2.5 installed. But the subscription has expired
> and rather than upgrade to the new version I installed Windows Defender.
>
>> What third-party firewall (if any)?
> I am using the Windows Firewall, only. No other firewall is installed.
>
>> Has a(another) Norton or McAfee application ever been installed on the
>> computer (e.g., a free-trial version that came preinstalled when you bought
>> it)?
> I am not aware of any other Norton or McAfee application being installed.  I
> may have run a McAfee installer from memory stick but stopped the
> installation when I realised that Norton needed to be removed first. (I
> cannot be certain as I may have run McAffee on another computer with Norton
> installed and realised I had to remove Norton before installing McAfee.)
>
> I realise that I am running a computer that is vulnerable to infection by
> malware. However, I have watched the processes running in Task Manager and
> checked out anything I thought suspicious. I have also checked System
> Information for running tasks/processes - which is how I discovered Live
> Update was still running. I have set the Security Settings of Internet
> Explorer to prompt me for pretty much everything a website might do in the
> Internet Zone, (some might think it annoying and that I am paranoid). and
> only have a few Trusted websites, like my bank and Microsoft Update. I have
> generally avoided installing software I don't know much about.  Though after
> I had problems with an application I downloaded, about a year ago, I went
> back and removed the downloaded file and checked my machine for possible
> infection by even checking the registry to ensure program keys and other
> references to the application were not present.  Nobody else uses my
> computer, so I don't think it is currently infected by malware - though I
> cannot be certain of that.
>
> -- 
>> ~Robear Dyer (PA Bear)
>> MS MVP-IE, Mail, Security, Windows Client - since 2002
> Thanks for your interest.
>
>> Huttite wrote:
>> > I am running Windows XP Home Service Pack 3 and was keeping up to date
>> > with
>> > updates until about a month ago when Windows Update offered about 10
>> > different Security Updates on one day.
>> >
>> > Now, after running Windows Update I keep getting the message that the
>> > following 5 updates have failed to install, even though other updates do
>> > install in the same run.
>> >
>> > Security Update for Windows XP (KB975713)
>> > Security Update for Windows XP (KB978037)
>> > Security Update for Windows XP (KB975560)
>> > Security Update for Windows XP (KB977914)
>> > Security Update for Windows XP (KB978706)
>> >
>> > All these updates fail with Error Code: 0x80070005
>> >
>> > I have noticed that none of these updates are ever downloaded
>> > automatically
>> > and all of them need to be downloaded first. All other updates that do
>> > install are automatically downloaded to my computer, if I check using the
>> > custom install option.
>> >
>> > I have tried the following:
>> > Install and run the Windows Genuine Advantage Diagnostic Tool
>> > Checked the KBxxxxx.LOG files for problems
>> > Install and run the latest Windows Genuine Advantage Notification Tool
>> > (Which reports I have a genuine copy of Windows)
>> > Run the Malicious Software Removal Tool (twice)
>> > Install and Run Windows Defender (which reports no problems)
>> > Run CHKDSK/F at startup.
>> > Uninstall (almost) all Symantec/Norton Antivirus software - (the Live
>> > Update
>> > icon in the control panel won't uninstall.)
>> > Checked that these updates have correctly installed on another XP-SP3
>> > computer (They have).
>> > Stopped the update service and reregistered the dll mentioned in KB943144
>> > Tried to install these updates separately, or just one at a time.
>> >
>> > None of these have been successful. What else can I do?
>> >
>> > (Note: Migrating to Windows 7 is not an option for this computer.)
>>
>> .
>> 

0
Peter
3/28/2010 4:42:02 AM
> Use these uninstall tools from Symantec and then the one from MaCafee and 
then post 
> back with result
> 
> Norton Removal Tool (Remove all Symantec listed products that is still installed)
> http://service1.symantec.com/SUPPORT/tsgeninfo.nsf/docid/2005033108162039
> 
> McAfee Removal Tool
> http://service.mcafee.com/FAQDocument.aspx?lc=1033&id=TS100507
> -- 
> Peter

Thanks, Peter, for those links, they will be helpful removing the rest of my 
unwanted anti-virus software, before I install some again! 

However, they do not address the root cause of the problem with Windows 
Update. I have found a solution after reading KB971058 - How do I reset 
Windows Update components? I ran Microsoft Fix It 50202 and then shutdown and 
restarted my computer. Once I did that the updates immediately started 
downloading and I will now try to install them using Custom Update, where I 
can see the 5 updates have all been downloaded and are ready to install. It 
probably means I will have to restart my computer again, so will be offline 
for a while. 
0
Utf
3/28/2010 6:12:04 AM
I think I have found a solution at

http://support.microsoft.com/kb/971058/en-us

which is KB971058 - How do I reset Windows Update components?

From there I ran Microsoft Fix It 50202 at 
http://go.microsoft.com/?linkid=9665683

After shutdown and restart Automatic Update started to downloaded the 5 
security updates almost immediately.  Custom updates on the Windows Update 
website now show the files have been downloaded and are now ready to install.



"Huttite" wrote:

> I am running Windows XP Home Service Pack 3 and was keeping up to date with 
> updates until about a month ago when Windows Update offered about 10 
> different Security Updates on one day.
> 
> Now, after running Windows Update I keep getting the message that the 
> following 5 updates have failed to install, even though other updates do 
> install in the same run.
> 
> Security Update for Windows XP (KB975713)
> Security Update for Windows XP (KB978037)
> Security Update for Windows XP (KB975560)
> Security Update for Windows XP (KB977914)
> Security Update for Windows XP (KB978706)
> 
> All these updates fail with Error Code: 0x80070005 
> 
> I have noticed that none of these updates are ever downloaded automatically 
> and all of them need to be downloaded first. All other updates that do 
> install are automatically downloaded to my computer, if I check using the 
> custom install option.
> 
> I have tried the following:
> Install and run the Windows Genuine Advantage Diagnostic Tool
> Checked the KBxxxxx.LOG files for problems
> Install and run the latest Windows Genuine Advantage Notification Tool
> (Which reports I have a genuine copy of Windows)
> Run the Malicious Software Removal Tool (twice)
> Install and Run Windows Defender (which reports no problems)
> Run CHKDSK/F at startup.
> Uninstall (almost) all Symantec/Norton Antivirus software - (the Live Update 
> icon in the control panel won't uninstall.)
> Checked that these updates have correctly installed on another XP-SP3 
> computer (They have).
> Stopped the update service and reregistered the dll mentioned in KB943144
> Tried to install these updates separately, or just one at a time.
> 
> None of these have been successful. What else can I do? 
> 
> (Note: Migrating to Windows 7 is not an option for this computer.)
0
Utf
3/28/2010 6:35:01 AM
>> What anti-virus application or security suite is installed and is your
>> subscription current?
>
> I currently only have Microsoft Defender running.

Windows Defender is NOT an anti-virus application.

The success you apprently have had after doing a Reset per KB971058 is 
likely to be short-lived if you do not have a valid, functional & 
fully-updated anti-virus application installed!


Huttite wrote:
>> 0x80070005: Access Denied
> I sort of gathered that. When I Google searched, I found commentary around
> the error code suggested to me that access was being denied because
> something had stopped Update recognising I had a genuine version of 
> windows.
>
>> Is this a sudden, new problem?
> This is a new problem that had a sudden onset when I was offed these 5
> Security Updates as part of a batch of 10-12 updates that were issued in
> February 2010. The other updates all downloaded and installed. These 5
> failed then and continue to fail, even though other updates released after
> them are downloaded and installed.
>
>>> I have tried the following...
>>> Uninstall (almost) all Symantec/Norton Antivirus software - (the Live
>>> Update icon in the control panel won't uninstall.)
>> Explain/Tell us more about this.
> I purchased my computer in 2002 with Norton 2002 preinstalled. That ran
> successfully being kept up to date until around 2007 when my subscription
> ran out and I could no longer renew it without upgrading/paying for a new
> antivirus application.  (I have an aversion to pre-planned software
> obsolescence.) It would still run though on the expired subsription -
> apparently. Then in late 2009 I acquired a new computer and a copy of
> McAfee, so attempted to uninstall Norton 2002 as a first step installing
> McAfee. While it seemed to uninstall the base Norton software, other 
> Norton
> (Live Update)/Symantic components were not uninstalled, and I only removed
> those yesterday. There is still a Norton Live Update icon in the control
> panel, even though I now appear to have no Norton/Symantic applications
> installed as Programs.  When I click the Icon it says that it is an
> "Applet" to control the setup of live update and gives a dialog box that
> allows me to adjust parameters like the check for updates frequency.
>
>> What anti-virus application or security suite is installed and is your
>> subscription current?
> I currently only have Microsoft Defender running. It was last updated
> successfully yesterday via Windows Update. It appears active and has
> detected changes made to the computer today (since posting the problem)
> while attempting to run  Microsoft Fix It 50202 - to see if resetting
> Windows Upgrade components will assist.
>
>> What anti-spyware applications (other than Defender)?
> I have had Lavasoft AdAware 2.5 installed. But the subscription has 
> expired
> and rather than upgrade to the new version I installed Windows Defender.
>
>> What third-party firewall (if any)?
> I am using the Windows Firewall, only. No other firewall is installed.
>
>> Has a(another) Norton or McAfee application ever been installed on the
>> computer (e.g., a free-trial version that came preinstalled when you 
>> bought
>> it)?
> I am not aware of any other Norton or McAfee application being installed. 
> I
> may have run a McAfee installer from memory stick but stopped the
> installation when I realised that Norton needed to be removed first. (I
> cannot be certain as I may have run McAffee on another computer with 
> Norton
> installed and realised I had to remove Norton before installing McAfee.)
>
> I realise that I am running a computer that is vulnerable to infection by
> malware. However, I have watched the processes running in Task Manager and
> checked out anything I thought suspicious. I have also checked System
> Information for running tasks/processes - which is how I discovered Live
> Update was still running. I have set the Security Settings of Internet
> Explorer to prompt me for pretty much everything a website might do in the
> Internet Zone, (some might think it annoying and that I am paranoid). and
> only have a few Trusted websites, like my bank and Microsoft Update. I 
> have
> generally avoided installing software I don't know much about.  Though 
> after
> I had problems with an application I downloaded, about a year ago, I went
> back and removed the downloaded file and checked my machine for possible
> infection by even checking the registry to ensure program keys and other
> references to the application were not present.  Nobody else uses my
> computer, so I don't think it is currently infected by malware - though I
> cannot be certain of that.
>
>> ~Robear Dyer (PA Bear)
>> MS MVP-IE, Mail, Security, Windows Client - since 2002
> Thanks for your interest.
>
>> Huttite wrote:
>>> I am running Windows XP Home Service Pack 3 and was keeping up to date
>>> with
>>> updates until about a month ago when Windows Update offered about 10
>>> different Security Updates on one day.
>>>
>>> Now, after running Windows Update I keep getting the message that the
>>> following 5 updates have failed to install, even though other updates do
>>> install in the same run.
>>>
>>> Security Update for Windows XP (KB975713)
>>> Security Update for Windows XP (KB978037)
>>> Security Update for Windows XP (KB975560)
>>> Security Update for Windows XP (KB977914)
>>> Security Update for Windows XP (KB978706)
>>>
>>> All these updates fail with Error Code: 0x80070005
>>>
>>> I have noticed that none of these updates are ever downloaded
>>> automatically
>>> and all of them need to be downloaded first. All other updates that do
>>> install are automatically downloaded to my computer, if I check using 
>>> the
>>> custom install option.
>>>
>>> I have tried the following:
>>> Install and run the Windows Genuine Advantage Diagnostic Tool
>>> Checked the KBxxxxx.LOG files for problems
>>> Install and run the latest Windows Genuine Advantage Notification Tool
>>> (Which reports I have a genuine copy of Windows)
>>> Run the Malicious Software Removal Tool (twice)
>>> Install and Run Windows Defender (which reports no problems)
>>> Run CHKDSK/F at startup.
>>> Uninstall (almost) all Symantec/Norton Antivirus software - (the Live
>>> Update
>>> icon in the control panel won't uninstall.)
>>> Checked that these updates have correctly installed on another XP-SP3
>>> computer (They have).
>>> Stopped the update service and reregistered the dll mentioned in 
>>> KB943144
>>> Tried to install these updates separately, or just one at a time.
>>>
>>> None of these have been successful. What else can I do?
>>>
>>> (Note: Migrating to Windows 7 is not an option for this computer.)
>>
>> . 

0
PA
3/29/2010 6:02:12 PM
Reply:

Similar Artilces:

Installing and using Office: MAC 2008 Home and Student Addition
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) My husband recently purchased a new MacBook Pro. He gave me his MacBook Air. Office Home and Student addition was installed on his old computer (MacBook Air), and was loaded on the new computer. I purchased my own copy of Office: MAC 2008 Home and Student and installed it on the MacBook Air but can't use when my husband is using his version. The product keys are obviously different, but when he's writing in Word, I cannot. The message is that two people can not use the program at once who are on the same network. What do I do so ...

VB Code help
Here is a portion of one of my VB Macros in Excel: If Selection.Count > 0 Then MsgBox ("Average = ") & (RunningTotal / Selection.Count), vbInformation, "Average" End If My question: How do I format the number (RunningTotal/Selection.Count) to look like 0.000, instead of 0.0000000000000000?? What should my code look like with the new formatting. Thanks Chris Chris, Try this: ....Format((RunningTotal / Selection.Count), "0.000")... -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- &qu...

Automatic Updates 09-12-10
I have a Dell Inspiron e1505 with Windows XP Home Edition - SP3. Overall workinig pretty good. I have Automatic Updates turned on and for some reason it keeps wanting to "Installing Microsoft .NET Framework 1.1 Service Pack 1 (update 1 of 1)... ", however just as it's starting a window entitled "SL18.tmp" pops up and says "SL18.tmp has encountered a problem and needs to close. We are sorry for the inconvenience." My only option at this point is to Close the window and then the Automatic Update stops, but then after a while it tries again with ...

Move Mailbox errors
I'm currently migrating from Exchange 2000 to Exchange 2003. We're in a native mode Windows 2003 AD. I am migrating about 500 mailbox from a standalone Exchange 2000 to a WIndows 2003 / Exchange 2003 Active/passive cluster configuration. Mailbox moves have been going great up until yesterday. While moving the users in the normal way,2 mailboxes hung at 100%. In the "state" column, it says: "Saving changes to the directory". I let it sit at this stage for more than 10 hours. I then have to cancel the task, then it says cancel running tasks, and this wil...

outlook 2007 error message in archive folders
for no discernable reason some and only some of my archive folders will no longer open and give the following error message: the message interface has returned an unknown error. If the problem persists restart Oultlook I have restarted not only outlook but rebooted my computer with no positive result. I have also gone back a month to a restore point but this has not changed the position. As I say it is only some files and then only some subfiles in larger files. One month ago there were no issues. I have added no new programs to the computer Try running scanpst.exe against y...

update from Office 98 to newer version?
Hi there! How do I update my microsoft Office 98 to a newer version? I have a office 2000 CD, which I received years ago, but I cant get it to work. Can I update over the internet on Microsoft homepage - and WHERE? Thanks a lot, Louisa You will need to purchase Office 2004 for the MAC http://www.microsoft.com/mac/products/office2004/howtobuy/howtobuy.aspx?pid=howtobuy See this for info on purchasing -- Paul Ballou MVP Office http://office.microsoft.com/clipart/default.aspx http://office.microsoft.com/templates http://office.microsoft.com/home Control the things you can and Don't Worr...

code to sum 8 textboxes
Hi there, I am trying to get a text box (txtsubtotal) to sum 8 other 'price' text boxes (txtprice1...txtprice8) when a command button (cmdCalculate) is clicked. Each 'price' text box is filled via a combo box (cboitem1) change code. Here is briefly what I have: Each combo box is coded like this: Private Sub cboItem1_change() Me.txtprice1 = WorksheetFunction.VLookup(Me.cboItem1, Worksheets _("Pizzas").Range("A:B"), 2, 0) End Sub Each 'price' text box is coded like this: Private Sub txtprice1_change() txtprice1.Value = Format(Me.tx...

Error Number: 0x800ccc0e when I try to get messages
Hello, I am a postmaster of our network and I am having some problems with Outlook 2000 and our pop3 server. The problem is that randomly, Outlook's users can not download their mail because they get the error number 0x800ccc0e when they try to send amd receive mail. We are using Microsoft Outlook 2000 SP-3 (9.0.0.6627) and our server is a Linux Debian running a 2.4.27 kernel. I have tried with ipop3d and in.qpopper as a pop3 daemons and with both I get the error. There is no firewall between them and this is the tcpdump capture from the server (our pop3 server runs at port 40110, bu...

80040e19 error occurring with 2nd NIC installed
I am experiencing the 80040e19 error when expanding public folders in Exchange System Manager, Exchange 2000. I have exhausted all suggested MS articles and *still* have not resolved the issue. No evidence of URLScan or iislockdown being run on the server. Strange thing is is that when I disable the newly installed NIC through device manager the public folders can be expanded perfectly. On enabling the NIC, same error. The server is the PDC, Exchange and Intranet server, running IIS on port 80 for local intranet site and the admin website on port 7715. I have checked the host head...

Workbooks that are not directly linked updating?
I have 3 workbooks: WB1, WB2, and WB3. WB1 and WB2 are both linked to WB3 but not each other. WB1 contains volumes and WB2 contains costs. When I open these two together and say no to updating the values change anyway. Any clue on why two workbooks update even if I say no or don't want to have WB3 open? -- MM ...

Installing SBS SP1 after Windows 2003 SP2 ?
Hi, I have a Small Business Server 2003 that has had 'Windows Server 2003 Service Pack 2' installed on it but 'Windows Small Business Server 2003 Service Pack 1' has NOT been installed on it. I found this out by running Best Practices Analyzer in preparation for migrating to Small Business Server 2008. Having SBS SP1 installed is one of the 2008 pre-requisites. Are there any issues with installing SBS SP1 after Window 2003 SP2 ? Regards Michael Shouldn’t be any problem. Just follow the procedures in the following (multi-page) article: How to install ...

how to put in sql code
first of all many thanks to Klatuu who has already helped me a lot!! I create my SQl code by means of some string concatenation. I do this so i can use the values of my field to create my SQl code. The problem is that some of these fields are double-populated eg. field location contains England and Brazil. My string creates "IIf([Table]![Location]" & [Location] & ",'OK', 'problem')" how can i populated the field location so that it is SQl-code? as =(Brazil or England) does not work as =Brazil or = England do...

Copy sheet in Excel
Hi Wonder if anyone of you encounter this problem before? When I try to copy worksheet in a workbook, the following prompt comes up, indicating name conflict. "A formula or sheet you want to move or copy contains the name 'aaaa', which already exists on the destination worksheet. Do you want to use this version of the name? - To use the name as defined in the destination sheet, click Yes - To rename the range referred to in the formula or worksheet, click No, and enter a new name in the Name Conflict dialog box" When I clicked yes, another prompt comes up indicating ...

space then date causes error
On my spreadsheet they have to type in a date and other calculations are taken from this point. Of the hundreds that have used it there have been no problems, however as always there will always be one....... When they fill in the date they type a space and then type the date, this throws up errors in the other calculations. Not altogether important but is there an easy fix for this, so that if anyone types a space it is ignored, I dont want to get involved in VBA/macro stuff. Right click the sheet tab>view code>insert this>modify range to suit Private Sub Worksheet_Change(By...

ameritrade plus error
When I try to download my information from ameritrade plus i get a invalid org error. Anyone else experience this problem. Help Please.. >When I try to download my information from ameritrade >plus i get a invalid org error. Anyone else experience >this problem? YES......EVERYONE!!!!!!!!! ...

Money2002 Setup Error
When I try to setup (windows98) I get the following: "This program has performed an illegal operation and will be shut down. If the problem persists, contact the program vendor." Here are the details: SETUP executed an invalid instruction in module ADVPACK.DLL at 015f:715f5858. Registers: EAX=0066cf04 CS=015f EIP=715f5858 EFLGS=00010206 EBX=0066d364 SS=0167 ESP=0066cdf4 EBP=0066d014 ECX=0066f8d0 DS=0167 ESI=00000348 FS=6017 EDX=0044003c ES=0167 EDI=0066d350 GS=0000 Bytes at CS:EIP: fe ff ff 50 ff 15 68 11 5f 71 56 8d 85 fc fe ff Stack dump: 00000080 bff77b14 71604004 00667000 0...

[Excel 2003] problem in files with pivottables after install Office Service Pack 3
Hi all. System: Windows XP Pro SP2, Office 2003 Professional + Service Pack 3 I have a problem with some xls files after install office service pack 3. With service pack 2 this files normal open. With service pack 3 after open file displays dialog (my translate from russian) "In workbook ... have contents which can not be read. Try restore contents of workbook ? If you trust source of this workbook, press button YES". If I press "No" - file not opens. If I press "Yes", displays next dialog. This dialog form content a list of corrections in file. Biggest pa...

Uninstall/Re-install CRM for Outlook
After installing CRM for Outlook on a client computer (Win XP and Office 2003), CRM 1.2, Exchange 2003, Server 2003, I had a problem with a profile, which I deleted. From that time on, nothing worked, the CRM for Outlook would not work, I could not uninstall the CRM from Add/Remove Programs (I get this message: "This action is only valid for products that are currently installed"). I can't re-install either as I am notified that the product is already installed. I can't remove folders (Microsoft CrM) as some files are in use... What to do? Could you please give ...

Gradual migrate from 5.5 to 2003 on 2000 Server
Can I concurrently run a 5.5 Exchange server and a 2003 Exchange server on a 2000 server AD domain? Currently have: one 2000 AD domain w/100 users w/ two 5.5 exchange servers running on 2000 (member) servers. I would like to add 2003 exchange (temporarily) on either a 2000 (member)server or a new 2003 (member) server and gradually migrate my users to that server. Once all the users are cleared off the old servers, upgrade the old servers to Exchange 2003 and move back the users. A. Is this nuts? B. Can this be done? C. Licensing during migration? Exchange CALs? KenS wrote: > Can I concu...

Error Occured Trying to Promote this email
This happens when trying to promote a email to CRM activity. Can anyone help? Bob ...

conversion ? #5
This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C5684A.7BCBCE70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How do you convert Quicken 2005 Files to Money 2005 ?=20 ------=_NextPart_000_000C_01C5684A.7BCBCE70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <...

Installing Exchange 2007 into exsiting organization
This is the first Exchange 2007 we have. Current environment is a mix of Exchange 2000 and 2003 in native mode. During the installation step, it is asking me to enter the name of organization, which I am hesitate to do -- I don't want to create a new Exchange organization under our domain. What should I do so it will pick up the exsiting organization and try to add itself into there ?? I am sorry, let me provide more info about the above post. I read this arcitle: http://technet.microsoft.com/en-us/library/54c6e6d4-aa19-4d30-87b6-31a1ca018a3f.aspx and was following the instruction ...

New User
Using Outlook 2003 with Exchange Server 2000 on XP Pro SP2 - all service packs updated. Attempted to setup a new user account on this system because previous employee has left and need new profile established. When attempt to setup email through Exchange and click 'Check Name' we get the following error: C:\Windows\System32\shell32.dll, Control_RunDLL C:\Program~1\Common~1\system\MSMAPI\1033\MLCFG32.cpl' "@0" The new user account will work fine on another system on the network, so the problem is not with Exchange but with this local system. Have tried deleting the pro...

Slow VBA Code
Any idea why this code is so slow? It used to run fine it now take around 20 seconds to complete any help would be appriciated. Sub record_new_record() Dim prev As Integer Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Application.EnableEvents = False Sheets("Records").Unprotect Sheets("Records").Select Range("A1").End(xlDown).Offset(1, 0).Select prev = ActiveCell.Offset(rowoffset:=-1, columnoffset:=0).Value Selection.Value = prev + 1 ActiveCell.Next.Select ' gives record an individual number automatically Sheets("...

GP 9.0 should allow to pin the drop down like in 7.5
I would like to have the ability to pin down the drop down's in GP 9.0. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=14f8fd0c-6996-4412-8ddc-1ac7c5d6b45a&dg=micro...