Archive for Office 2007

MSXML 6 Service Pack 2 Failed

Good night!  It took me several hours and lots of frustration today just to get Outlook Business Contact Manager 2007 installed.  Actually, to be most accurate, it took me that long just to get SQL Server Express Edition installed.  I would get almost done and then get a failure message.  The logs would indicate that

MSXML 6 Service Pack 2 (KB954459) 6.20.1099.0 Failed.

Ok, seems easy enough, uninstall the darn thing and try again, right?  WRONG.  It gave me the same darned error message when I tried to uninstall it to.

A quick Google search had me installing and using the Windows Install Cleanup Tool to completely remove MSXML 6 Service Pack 2 and a quick reboot had me back on track with the contact manager software installed in no time.  I had never heard of this program before, but I will be adding it to my list of tools.


Desktop Support – Linking Contacts in Office 2007

When working for a small company, I am finding that it is often necessary for me to be the desktop support  technician as well as the backup gal, server dudette, and network wirer.  I guess this is perfect for me, since I have always been more of a jack of all trades, master of none type of person anyway.   I can also usually track down the answer to any question, if given enough time and resources (usually 2 minutes and Google).

That is what it took to find the answer to the question for today.  I had a user ask me today how to link contacts in Office 2007.  He said he had done it in the older version, but could not find any information on how to do in 2007.  I personally have never linked contacts, so I had no idea what he was talking about, but as he seemed quite distressed, I jumped on Google to see what I could find.  Thankfully, this article by Jennifer Kershaw was just what I needed to be the hero today.

Here is the quick rundown; Open Outlook 2007, go to Tools –> Options –> Contact Options –> check the box next to “Show Contact Linkin gon all Forms” and wallah!  Now each contact has a box at the bottom right allowing you to link contacts to other contacts in your list.

Office Demos

It is almost Christmas, so I have set aside my studying for a few days, but still needed to work on some training for Office 2007 and stumbled upon a site many probably use all the time, but was new to me.

Microsoft has really become more user friendly in the past couple of years, and one sure sign of that is the wealth of information they have on their Office Online sites.  In addition to some really great trainging materials, the also have some great demos.

I took some tips and created an article for our newsletter, but I will also be sending my customers more often to the Office site so they too can get the information that they need. 

I often find that desktop support takes up a large part of my day if I let it, and I also have found that the more training and guiding I do is less time I have to spend later answering the more basic how-to quetions from my users. 

By the way, I also have some users who are still using Office 2003 and one or two stuck on Office 2000 and there are links from them from this site too.

Access 2007 Issues With Spec Sheets

We have recently installed Office 2007 on new computers we are ordering, and our Spec Sheet that all of our cutomer reps use would not open. It turns out that there are two fixes that must be applied.

First, we have to set Access to not show the “Action Queries”

  • Click on the Office 2007 symbol on the top left
  • Click on the “Access Options” button at the bottom right
  • Go to the Advanced Tab
  • Look Under the Editing and Confirm options
  • Uncheck the third box down, “Action queries”

Second, we also need to change the Trust Center Settings

  • Click on the Office 2007 symbol on the top left
  • Click on the “Access Options” button at the bottom right
  • Go to the Trust Center Tab
  • Click on the link to go to the Trust Center Settings on the right
  • Click on the Trusted Locations option
  • Put a check in the box to “Allow trusted locations on my network”
  • Add the location (server) of the Spec Sheet