DavidOverton.com
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  

July 2007 - David Overton's Blog

  • How to get rid of the installer / configuration dialog when running Office 2007 and Office 2003 on the same system - for Vista and other versions of Windows

    I have been asked this many times following up on the blog entry Installing Office 2003 and Office 2007 on the same system where once people have removed the problem with the End User Licensing Agreement (EULA) appearing every time they start Office they then get the dialogs below every time they switch between Word 2007 and Word 2003. when starting Word 2003 when starting Word 2007 The fix to the problem is very simple as it turns out - simply run the following commands (by pressing the Windows Key+R or typing it into the Start/Run command box. Use the line with Office\11.0 if you have Office 2003 installed and Office\12.0 if you have Office 2007 installed. You can use both if you have both installed : reg add HKCU\Software\Microsoft\Office\11.0\Word\Options /v NoReReg /t REG_DWORD /d 1 reg add HKCU\Software\Microsoft\Office\12.0\Word\Options /v NoReReg /t REG_DWORD /d 1 That is it. Office 2007 might want to have one more spin round the block with it's configuration dialog box, but that should be it. ttfn...
  • How to get the Office Assistant in Office 2003 (clippy) to work in Windows Vista, i.e. remove the "Not enough memory" error messages

    [updated 24th January 2009 with new download location for x64 systems] [updated 31st December 2009 with Windows 7 information] I have been asked this question several times and finally dug into the system to make it work. N.B. while this will work with Windows 7 the "agent" will have a pink background. Given the age of this technology it is unlikely to be fixed. The solution The Office Assistant relies on some "agent" technologies. To fix this we need to install the agent technologies and then copy a DLL across. Since I was playing around it is possible that there is an extra step or two that is not actually needed, but since this is a small process and simple to do I don't think it will do any harm. What is more, I was not about to rebuild a system, load Vista and Office 2003 just to see if I could remove a 10 second step :-) Download the MSAgent technology from http://www.microsoft.com/msagent - select the CORE files, so for me that was this item - Download the Microsoft Agent core components...
  • How to enable cached mode for Outlook when used inside Terminal Server (which means that BCM can work too)

    OK, this is in response to the people who have posted on this subject. Someone was kind enough to give me the exact details, but I shall protect my sources except to say they know the insides of MS tools well. The warning here is that this is unsupported and could completely destroy your users profiles, so only do this is you are comfortable editing the registry The short description: Open up Regedit navigate to [HKCU\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem\Profiles\<ProfileName>\13dbb0c8aa05101a9bb000aa002fc45a] Find the key 00036601 (REG_BINARY) - note the number in it now so you can undo the changes if needed Change the value to one of the following enabled value; 84 01 00 00 - note that on my desktop system the enabled value is 84 19 00 00, so play around with this a little enabled with Public Folders/Favorites: 84 05 00 00 disabled value; 04 00 00 00 FYI - you will need to search for "00036601" and adjust ALL of them since each key is for a different user on...
  • July Action Pack Kit shipments

    Hopefully, this is what will ship in the July kit: Name Language # of licenses # of CALs Microsoft® System Center Essentials 2007 English 10 NA Microsoft® Windows Server 2008 32 and 64 bit Beta English 1 10 Windows Server® 2003 R2 32 and 64 bit English 1 10 Windows VistaTM Business 64 bit English, French, German, Spanish, Italian, Portuguese, Danish, Finnish, Dutch, Hungarian, Czech, Polish *** *** ttfn David
  • David Overton moving on to pastures new

    With a tear in my eye the time has come for me to move my stick hut somewhere new. I have loved working in and with the small business community and with a set of awesome partners who can complain and nag, but normally with good cause and that are more willing to say thank-you and "good job" when the time is right. To you all I take my hat off for making me feel so welcome. As a legacy we now have SBSC up and running, partner groups that support themselves, a voice into Microsoft from the smaller end of the partner community and a better understanding of the motivations of both Microsoft and our partners. We also have a new level of engagement with customers. I wish I could take credit for all of this, but I am just a figurehead for a great team of people inside Microsoft. A nice chap called Mark in the OEM team will be helping to drive Cougar knowledge through the community when the time comes (no, this is not the time yet, trust me), SBSC has been supported by Jen as many of you would have seen from...
  • How to copy files to a DVD / CD, Use the recycle bin, Use previous versions for files and Use the built in Vista backup tools - all in a Video presented with Silverlight

    The Video I have delivered a number of Vista and Office demos over my time, so I decided to record a number of them for others to borrow, use, learn from or anything else they choose. This video covers the following subjects in enough detail for people to hopefully understand what they need to know on how to use these tools: Use of the recycle bin Use of shadow copies to undo changes to a document Use of the DVD writing tools to copy and update files on a DVD Use of the built in Vista Backup tools To see the Backup Video played using Silverlight (just try it) click here *. If you want to download it as a WMV file then head over to the new bCentral - the UK Small Business Center on MS.com - It should appear on this page soon. * it will take a few moments to open if you have Silverlight installed and require you to download Silverlight if you don't, but it is a 1MB download How I made it I simply ran through part of my normal demo talking as I went. When presenting to an audience it is easy to correct anything...
  • Adding SBS to an existing domain

    There was a short burst on e-mail the other day about this, but I thought I would share. The situation was that someone was adding SBS to an existing domain, not a problem, but the existing domain had some trusts set up. Since SBS does not support trusts things did not go well. So, to follow up we need to remind everyone that when doing this you get a short period of time to make everything within the SBS constraints or things stop working. Details on how to do all of this are documented in the Knowledge Base (KB)article mentioned below. Here are the bones of the internal notes: You can add one SBS to an existing domain, but the SBS requirements have to be met within a certain grace period. (14 days, according to KB 884453 .) By the end of that grace period: The new SBS 2003 computer must be a domain controller that is installed on the root of the domain. The new SBS 2003 computer must hold all the Flexible Single Master Operation (FSMO) roles. The new SBS 2003 computer must be a global catalog server and must...
  • How to connect to and import data from an XML Web Service into Excel 2007

    I have been wondering how to do this recently for one of my own projects and then the subject came up internally. A very unassuming Hovsep then wrote up the answer, so as a tip here it is - if you follow the link at the bottom you will see a step by step process with screen shots to help you along the way. Excel 2007 - How to connect to and import data from an XML Web Service Many organizations have adopted a Service-Oriented Architecture (SOA) as the architecture of choice. SOA allows a company to expose its services and data in a manner that is compliant with industry standards. SOA is the buzzword these days. Down the wire of SOA is XML data that is exchanged between entities. Microsoft Office Excel 2007 has built-in features that allow a user to connect to and consume XML data. Such data can be stored in an XML file on the local hard drive, shared in a portal or returned from an XML Web Service. If you’d like to use Excel to import XML data from a Web Service, follow these step-by-step guidelines. For the...
  • Its a shame when plans don't work out - another side of the story (When Linux drives you to Windows)

    The e-week article Windows Server Woos Linux Customers has some very interest facts. Not all of them are pro-Microsoft, but it does show that some of the marketing fluff out there is not quite right yet either. The migrations come after a quarter in which Windows Server revenue grew faster than Linux revenue—the first time that has happened since research company IDC started tracking Linux server spending in 1998. Recent Linux-to-Windows converts include consumer products manufacturer Unilever, online retailer Overstock.com, French sports yacht Areva Challenge (the French entry for the 32nd America's Cup yacht race), and California candy maker Jelly Belly. Windows is particularly gaining ground against Unix and Linux on the supercomputing front, a space that Microsoft did not play in until 2006, when it released its Windows Compute Cluster Server 2003 product. <snip> Candy maker Jelly Belly, of Fairfield, Calif., had a challenge of a different kind: Its Linux-based VPN software, which it declined to...
  • Business Contact Manager 2007 (BCM) is NOT supported on Windows Terminal Server, but a little hack will make it work

    [updated on 28th July] Hi, I've pinged this around a bit internally and the answer I got back is that this is not supported and will not work. I have not tried it myself, but don't expect it to work. If you need this sort of functionality you need to look at MS-CRM I am afraid. History: You need a Volume License of Office 2007 to run in Terminal Services. You can get BCM with Volume Licensing of Office 2007 as noted at http://office.microsoft.com/en-gb/suites/FX101635841033.aspx Outlook running in Terminal Services does not run in cached mode - http://technet2.microsoft.com/Office/en-us/library/ba930d00-dc38-4564-ad00-8304d74f1d8c1033.mspx?mfr=true 3) BCM requires Outlook to run in cached mode (Office 2003 note in a KB about this - http://support.microsoft.com/kb/831747/en-us and I have had PSS confirm this is still the case with BCM and Office 2007) Wish this was not the case, but better to say up front rather than pretend. Now, updated, if you look at How to enable cached mode for Outlook when used inside...
  • How to find and use an Accounting template to use with Office Excel 2007 and then change it from US to UK currency, change the formatting of dates and drag lists (or Excel Tips and Tricks 1) - all in a Video presented with Silverlight

    The Video I have delivered a number of Vista and Office demos over my time, so I decided to record a number of them for others to borrow, use, learn from or anything else they choose. This video covers the following subjects in enough detail for people to hopefully understand what they need to know on how to use these features in Excel 2007 and apply them to all of the Office 2007 applications: Find a template and use it - I use an accounting template as it is based on Office 2003 and US based Change the currency cells from dollars to pounds using find and replace for formatting Change the date formatting from US to UK Dragging a list across a range of cells to give column a different month To see the Excel 2007 Video played using Silverlight (just try it) click here *. If you want to download it as a WMV file then head over to the new bCentral - the UK Small Business Center on MS.com - It is on this page as an Excel Accounting sample: * it will take a few moments to open if you have Silverlight installed and...
  • How to customize Business Contact Manager 2007 forms in Outlook 2007

    I found this on the Office Website when someone asked me about form customisation for BCM. I thought I would share it. Demo: Customize Business Contact Manager forms You can customize Microsoft Office Outlook 2007 with Business Contact Manager forms by adding fields and list items (drop-down lists) that are unique to your business. You can customize the following types of forms: Account Business Contact Opportunity Business Project You can customize drop-down lists by clicking Edit this list and then adding your item to the list. Watch this short demo to see how to customize a Business Contact Manager for Outlook form. How to do it (text version) Customize your Business Contact Manager forms through user-defined fields Customize drop-down lists on Business Contact Manager forms Demo: Customize Business Contact Manager forms - Outlook - Microsoft Office Online ttfn David Technorati Tags: Business Contact Manager , BCM , Customise , Customize
  • Why should a small business use Office 2007

    Once again I thought I would put pen to e-paper on the top reasons I give people to move to Office 2007. I don't think there are many businesses out there that use a PC and don't use some form of office productivity suite and while most use Microsoft Office XX (where XX could be 97, 2000, XP or 2003), some use other products that in my opinion just don't compare for a business that wants to look great and work efficiently. With Office offering a massive choice of products and features, these are the headlines I use when talking to people. For those with a version of Microsoft Office, but not 2007 More Professional and Impressive documents and materials Use Microsoft Publisher 2007 to build sales and marketing materials that look agency made, but are actually in-house work The updated Microsoft Word 2007 has many features to ensure your documents have a professional, consistent look and feel throughout the whole document conforming to your brand goals (no matter how big or small they might be). The...
  • Show Classic Menus and Toolbars on Ribbon of Office 2007 - two product choices

    I saw a blog entry at Susan Bradley's blog about her now deploying Office 2007 with a classic menu . It was worth of a blog link for all those who want to stick to the old, old ways where you search for items over multiple menus (especially if you turn on personalised menus which hide all the things you don't use regularly). The tool looks slick, but then I found a 2nd one are realised that some cunning ISVs had seen this as their great opportunity to fill a gap that is very unlikely to be filled by Microsoft. The Two solutions are shown below and can be linked to from pschmid.net - RibbonCustomizer™ Feature Tour - Part 3: Classic UI Tabs and Show Classic Menus and Toolbars on Ribbon of Office 2007 : V1.1 Feature Tour - Part 3: Classic UI Tabs RibbonCustomizer™ V1.1 ships with a set of Classic UI tabs for Excel, PowerPoint and Word 2007. Those tabs emulate the Office 2003 menus and toolbars in Office 2007. We provide these tabs to help you familiarize yourself faster with the new Ribbon User Interface...
  • How to use Office Outlook 2007 with any internet connection and how to access Outlook Web Access from any web browser - all in a Video presented with Silverlight

    The Video I have delivered a number of Vista and Office demos over my time, so I decided to record a number of them for others to borrow, use, learn from or anything else they choose. This video covers the following subjects in enough detail for people to hopefully understand what they need to know on how to use Outlook via a web browser and via an internet connection: Outlook Web Access with recent browser (IE5 or above) Outlook Web Access basic or lite edition for low speed internet connections Configure Outlook to use RPC over HTTP To see the video played using Silverlight (just try it) click here *. I am hoping that in the near future that the WMV file will be available at new bCentral - the UK Small Business Center on MS.com. At the moment it is not available there, but a copy can be found here * it will take a few moments to open if you have Silverlight installed and require you to download Silverlight if you don't, but it is a 1MB download How I made it I simply ran through part of my normal demo talking...
  • Why should a business get Windows Small Business Server 2003 (SBS) to help their business

    I have been asked this many times and had promised to put these things down on paper (well e-paper), so now I am. This is my thoughts on why someone should buy SBS and also how I would sell it if I was selling it. Obviously there is much more that can be said and tailoring a solution to a customers needs is vital, but if presenting at an event or describing it on the radio, this is what I would say. Windows Small Business Server 2003 (SBS) is priced lower than other Microsoft servers to enable a small business to get the benefits of servers without any functionality compromise. We have even enhanced the product to put MORE in there than a standard Windows Server. To enable this price benefit Microsoft has put some limits (see below) on how SBS can be used which basically stops big businesses from using it, however you can cash in your investment in SBS and buy an Enterprise server should you ever need to and use the "cashed" in value to make the Enterprise server easier to afford too. Having said all...
  • Malware Removal Kit from Microsoft, including a boot from CD solution

    Malware Removal Kit The Malware Removal Kit is a download from TechNet that provides you with excellent guidance and tools to help you restore PCs infected with malware. The newest Solution Accelerator from Microsoft, it provides free, tested guidance to help you combat malware attacks and restore infected systems - so users can safely get back to work. The kit shows you how to use the Windows Preinstallation Environment (Windows PE) to discover malware by performing a thorough offline scan of your computers, uncovering malware that may be hiding in the operating system. And once malware is located and identified, it can be quickly removed from infected PCs with a number of free anti-malware tools, like the Malicious Software Removal Tool from Microsoft. ttfn David Technorati Tags: Malware Removal , WinPE , Security
  • Upgrading to Office 2007 using retail boxes - what can you upgrade from

    [updated to change blog title to something meaningful] I was asked about this today - for those people with retail copies of Office, what can they upgrade from to Office 2007. Full details on Word, Excel, Access, Publisher and the suites can be found at 2007 Microsoft Office system pricing - Products - Microsoft Office Online . To see if you have a retail box of an earlier version of Office and if it will load without you needing to upgrade onto a new machine with Vista, have a look at http://uksbsguy.com/blogs/doverton/archive/2007/05/09/buying-vista-and-then-installing-an-old-version-of-office-whatare-you-allowed-to-do.aspx 2007 Microsoft Office suites 2007 Microsoft Office Suites Estimated Retail Price /Upgrade Price Qualifying Products for Upgrade Microsoft Office Basic 2007 Available only through OEMs; price not quoted Upgrade not applicable. Microsoft Office Home and Student 2007 $149/NA Upgrade not applicable. Microsoft Office Standard 2007 $399/$239 Microsoft Works 6.0–10; Microsoft Works suite 2000–2006...
  • Want TechNet Direct for free - that is all out software for trial and 2 support calls - simply submit two assessments to the Microsoft Business and Technology Assessment Toolkit

    I have always like the Assess and win program along with the Technology Assessment Toolkit, although some say they have little to learn from it. It is one of those things where someone says "I need more stuff from Microsoft, but not anything to help me sell because I am great at that already." A partner who I respected told me that the format of the kit did not work for them, but they took the questions and used them as a checklist, added some of their own and now it works well. They also said that they don't run through the questions one after another, but have a conversation with their customer, and then fill in the blanks at the end. Anyway, the toolkit is a great way to understand more about your customer and their motivations and then plug some generic data into the engine inside Microsoft that tries to build solutions that match your customers needs. Technet Direct gives you DOWNLOAD access to almost all of Microsoft's software AND two free support calls - and you get this for FREE after...
  • Technet Answers on licensing Office 2007 for Terminal Server and Disaster Recovery licensing

    I was reading the latest Technet newsletter and saw this and thought I would pass on these two items: 2. How do I license Microsoft Office so my users can access it over Terminal Service? Microsoft has produced a Word document (126Kb) that discusses the options available to customers who would like to configure access to Office in this way. 3. How does Microsoft license its products for use in a disaster recovery situation? View the guide to "Cold" Server Back-Up for Disaster Recovery" . ttfn David Technorati Tags: Licensing , DR , Disaster Recovery , Office 2007 , Terminal Services
  • Want to know what is happening on your network, packet for packet - get Microsoft Network Monitor 3.1

    I saw this had been published and thought I would share - it is an amazing tool that I use for diagnosis all the time. Reading http://www.ditii.com/2007/07/03/network-monitor-31-released/ it also reminded me that this includes traces on wireless networks!! Microsoft Network Monitor 3.1 Network Monitor 3.1 is a protocol analyzer. It allows you to capture network traffic, view and analyze it. Version 3.1 is an update and replaces Network Monitor 3.0. Network Monitor 3.x is a complete overhaul of the previous Network Monitor 2.x version. Supported Operating Systems: Windows Server 2003; Windows Server 2003 x64 editions; Windows Vista; Windows XP; Windows XP 64-bit It is suggested that you have a CPU of 1GHz or greater, 1G or greater of Memory and 25 Megs of available Hard Disk space, plus room for capture files. Supports Vista 64 bit as well as 32 bit. Instructions Network Monitor 3.1 can co-exist with Netmon2.x. NM3.1 installs in %program files%\Microsoft Network Monitor 3, so there is no conflict. But it will require...
  • Windows SharePoint Services (WSS) v3, SharePoint Portal and Office Communicator, Partner Sales 101 and Dynamics and CRM training

    Office Communications Server 2007 Ignite Workshop This two-day workshop introduces many of the new features and capabilities that are built into Microsoft Office Communications Server 2007, including Rich Presence, Instant Messaging, Audio/Video Conferencing, and Voice. Click here to enrol. Implementing and Maintaining Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 Course This is a residential, intensive and compressed course intended for those partners who want to get a head start on the new SharePoint certifications. Ten days compressed into five Training for 12+ hours a day Residential course, with 24 hour availability of labs and instructor Exams taken during the week Limited number of seats – few deliveries are planned, so if you want your Partners to attend please encourage them to sign up now Click here for more information or to enrol Partner Sales 101 The next one is being held on the 11 th September 2007 Aim: This session will equip sales people with the knowledge and skills...
  • How to add a trade-in line item (i.e. give cash back to discount a deal) to BCM 2007

    Someone asked me how to do this and I discovered that you can't have a negative discount percentage, negative quantity or negative price. So this makes it impossible to do... well, no, but it is not quite as easy as we would like. To make it work you need to create a Product and Service csv file to import to make it work. Here are the step by step instructions on installing it and using it. Installing the trade-in items Go to the BCM menu and select the Product and Services menu item Press the import button at the bottom of the dialog to get the screen shown on the left Create a csv file on your desktop called tradein.csv (start / run "notepad %homepath%\tradein.csv") Copy and paste the text below into the text file and save Trade In (10000), Trade in, -10000 Trade In (1000), Trade in, -1000 Trade In (100), Trade in, -100 Trade In (10), Trade in, -10 Trade In (1), Trade in, -1 browse the csv file on your desktop and press import Job done Using the trade-in items in an opportunity Now we have these...
  • SBS 2003 R2 Premium Edition, Downgrade options, including SQL 2005 to SQL 2000 - for a limited time only

    In a recent announcement we now offer the ability to downgrade the Premium technologies in R2. More information can be found at http://www.microsoft.com/windowsserver2003/sbs/downgrade/default.mspx with a FAQ at http://www.microsoft.com/windowsserver2003/sbs/evaluation/faq/bizsolutions.mspx . Please note that this is a time limited capability due to the End of standard support of SQL 2000. If you have licensed a copy of Windows Small Business Server 2003 R2 Premium Edition (which includes Microsoft SQL Server 2005 Workgroup Edition), but your line of business applications are not yet available on the Microsoft SQL Server 2005 platform, you may be able to request downgrade rights to SBS 2003 SP1 Premium (which includes Microsoft SQL Server 2000 Standard Edition the version of Microsoft SQL Server that shipped with Small Business Server 2003 and SP1), and use the downgraded SQL Server in your SBS 2003 R2 environment. You may exercise this downgrade through the channel in which you licensed your original version...
  • Star Wars Celebration Europe - How I got to re-shoot the Imperial storming of the Tantive IV and the final movie

    OK, so still need to do a all up post, but before I do, here is how I got to re-make the video. One item at the event was part of the set for the Tantive IV. The nice director and actors explained how shooting from different angles and by swapping bits out the set could be made to look even bigger etc. They then asked for 6 volunteers to be the "rebels" who die in this shoot. I was lucky enough to be picked, so off I went to wardrobe (yes, a proper costume maker, costumes and props). I quickly put on my rebel uniform with my 5 hapless colleagues and off we went to be briefed. We had to shoot 3 scenes and then these were to be edited into the original film, Scene 1- Running down the corridor toward the place we expect the imperials to board. while we are running, an explosion will rock us back (you have to act the explosion) and then on we go. Scene 2 - Run into position, line up your sites, then look above and back as you hear a noise and wonder what it is, then focus again on the big door. We had all...
1 2 3 Next >

(c)David Overton 2006-23