David Overton's Blog and Discussion Site
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.  

Browse by Tags

  • SharePoint continues to grow - now being considered "viral" in it's take up and what you can do about it.

    From a Microsoft and Microsoft Partner point of view the press article below is great news. IT departments are finding users who are deploying SharePoint to get the benefits and the easy of use that SharePoint offers as well as developers who are building on SharePoint as an application Platform. I recently had a partner who told me that their belief was that Windows 32/64 was the desktop and server operating system, but they saw SharePoint as the web OS. Given the benefits that SP1 provides to SharePoint this is even more the case. http://napps.networkworld.com/news/2007/120707-microsoft-sharepoint.html The analyst firm CMS Watch is claiming the newest version of Microsoft ’s SharePoint is spreading “virally” throughout enterprises, catching IT departments off guard and introducing risks related to uncontrolled content and regulatory compliance . […] CMS Watch says viral proliferation of SharePoint is nothing new, going back to the 2003 version. But Pelz-Sharpe says the “problem is becoming acute now” with the...
  • Things that have fixed peoples problem running Office on Vista

    From the blog entry I published on 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 still get people e-mailing me with problems. While I have not been able to solve them all, but here are some solutions that I have seen success with: Problem: POP3 e-mail starts sending then gets stuck/hangs/stops: I have seen your blog at uksbsguy.com and it seems you are my only hope. Brand new laptop, small sized PST file, Vista Home Premium, Outlook 2007 Ultimate. I set up an account in Outlook 2007 to my bog standard POP3 account that has always worked. It starts to download my first email and slowly reaches 3 or 4KB then just hangs . Surprisingly I can sent (SMTP) absolutely fine. If I use another internet connection (dial up modem) instead of LAN then I can receive POP3 as well. But the same LAN connection works for my old laptop (XP/Outlook 2003) all settings same. I also tried the netsh command and the result is...
  • Open Office 2007 attachments to Outlook Mobile e-mail on Windows Mobile 5 or 6 - update released

    [updated on 4th December with UK English install instructions] As Steve would say, hat tip to Steve's blog . Microsoft Office Mobile 6.1 If you run Windows Mobile 5 or 6 and run Office 2007 (or get attachments from friends that do) this is a must have . You can now read Office 2007 file formats on your mobile device. More details from Jason :) [UK English Install] For those of us not in the US of A this install will complain about installing on our UK English (or other) devices. Fear not, go to the settings screen, move to region settings and change the language to US English. Ignore the prompt to reboot, run the setup on your PC. Once it is all finished it will need to reboot your device. Do so, set the language back to UK English and you now have an updated device. There is no English_UK install :-) ttfn David Technorati Tags: Windows Mobile , Office 2007
  • How to turn on e-mail logging in Office 2007 and ensure that your ports are open

    I was asked about this a while back and thought I would share. This person has e-mail receiving problems, so I wanted to turn on logging and check that the network ports were really open on his PC: To get a mail log for more details – go to Tools/Options – then the advanced tab/Other button/Enable logging. (mine is not checked – put a tick in yours). The location of the log file can be found at: MAPI (Exchange), POP3, and SMTP transports - The log file has the name OPMLog.log and is located in one of the following locations: c:\Users\ user name \AppData\Local\Temp\Outlook Logging - note this is the location on Windows VISTA You might also want to look at http://www.webpipe.net/howto/Outlook_0x800CCC0E . You will need to install at telnet, but this is documented as: By default, Telnet is not installed with Windows, but you can install it by following the steps below. To install Telnet Client 1. Click the Start button , click Control Panel, click Programs, and then click Turn Windows features on or off. If you are...
  • Microsoft Office System Developer Conference - February 10-13th 2008

    Where: San Jose Convention Center , San Jose, CA Who: 2000 developers and architects who build solutions on the Office platform (Office clients, servers, and services) ODC 2008 will bring together architects, developers, industry technical experts, Microsoft insiders and key partners in a public forum for the first time! Together, we will redefine what it means to be focused on Microsoft Office development, exchange ideas on how to continue innovating in this ever-changing space, and share best practices on how to craft the next generation of Office Business Applications . Microsoft Chairman Bill Gates will deliver a special keynote that is not to be missed (and probably one of the last ones, so be there!!). The web site http://www.odc2008.com is now live. Who is the Microsoft Office System Developer Conference for? Those involved or interested in using the Microsoft Office system (clients, servers, and services) as an application development platform. For example, people in technical roles e.g. architects, developers...
  • Download the "How to Sell, Deploy, and Build Business with Microsoft Windows Sharepoint Services 3.0 and SBS 2003 R2" now

    I have been asked about this loads of times, but for those of you who want to know more about using WSS v3 and SBS 2003, the guide is finally here at http://www.microsoft.com/downloads/details.aspx?FamilyID=59acc518-023e-43c3-b8f3-378c5e387461 . How to Sell, Deploy, and Build Business with Microsoft Windows Sharepoint Services 3.0 and SBS 2003 R2 Partner tool to create solutions using Windows SharePoint Services 3.0 and Windows Small Business Server 2003 R2. File Name: Selling_WSS_and_SBS_Kit.zip Date Published: 11/15/2007 Overview A new partner enablement tool helps you create solutions using Windows SharePoint Services 3.0 and Windows Small Business Server 2003 R2. Access the toolkit’s resources—including a process cookbook, technical documentation and marketing materials—to learn how to build your business by selling and deploying customized solutions. ttfn David Technorati Tags: SBS 2003 R2 , SBSC , WSS v3 , WSS , SharePoint , Windows SharePoint Services
  • How to make Office 2007 always save in Office 97-2003 format

    This is another area I get a lot of questions, so I thought I would share the answer. While my person preference is to tell people to load the tools onto Office 2000/XP/2003 machines as documented at How to open Office 2007 (Word, Excel, and PowerPoint 2007) files on Office 2000, Office XP and Office 2003 by downloading the Microsoft Office Compatibility Pack for File Formats - David Overton's Blog for some people this is not an option. So, how do you force Office to save in the older format? If you want to do it to lots of machines then look at http://msmvps.com/blogs/bradley/archive/2007/07/14/default-save-as-doc-and-xls.aspx . If you want to do it on your own personal machine, try this: Go the the "Opal" or the round Office button, and select Word Options Then go to the save tab and choose the file format you want, so Word 97-2003 for .doc files. You need to do the save in Excel and PowerPoint to get those too do it too. ttfn David Technorati Tags: Office 2007 , Office 2003 , Office XP , Office...
  • MSDN Evaluation Center for Office system, Biztalk, SQL Server 2005/2008 and Windows Server 2008

    I just found the MSDN Evaluation Center online today to give you evaluation resources that you might develop against. These include BizTalk Server, Office Communication Server, Office Enterprise , SharePoint Server, SharePoint Designer, SQL Server 2005, 2008, Express 2005 SP2, Windows Server 2008. I've pasted much of the content, but all the download links etc are country specific, so I have removed those. Click on the link above to get to download this stuff! MSDN Evaluation Centre Welcome to the MSDN Evaluation Centre, the central location for all Microsoft developer product trials and beta evaluations. Try a product before you buy it or test the latest beta to see what is in store for the next release. Start at the beginning of the evaluation process and follow the new products as they go through to the final releases. Remember to check back often as new products will be added as they become available. As you evaluate your software, we'll provide you with comprehensive and relevant insights and information...
  • Office Open XML file format information or Standard ECMA-376 and the OOXML SDK information on MSDN

    I saw this question asked internally today, so I thought I would share. If you want to develop to use the Open XML document format you probably want to look at two things. The Microsoft resources (eg http://msdn2.microsoft.com/en-gb/office/aa905545.aspx ) and the ECMA resources Standard ECMA-376 . On the MSDN site you will find documentation and a MS SDK (less interest if you are developing using a functional language for your mainframe ). The ECMA site has the following: Standard ECMA-376 Office Open XML File Formats (December 2006) This Standard defines Office Open XML's vocabularies and document representation and packaging. It also specifies requirements for consumers and producers of Office Open XML. An Office Open XML overview is available on the Ecma website. Copy these file(s), free of charge: File name Size (Bytes) Content ECMA-376 Part 1 350 630 zipped DOCX file ECMA-376 Part 1 1 441 795 zipped PDF file ECMA-376 Part 2 341 625 zipped DOCX file with 2 Annexes ECMA-376 Part 2 1 286 494 zipped PDF file...
  • What is in Office Accounting for accountants... well, multiple account views, sharing, customisation and more, but it is not an practice management solution

    I saw that someone said on one of the online forums that there was not anything in Office Accounting for Accountants. I beg to differ. This product is not something that offers anywhere near the same capabilities of someone like Iris for Practice Management - it is not designed to do so, it is aimed at small businesses who want a simple to use accounting package and then a tool for accountants to simply extract and manage data from it. I am not an accountant, but Microsoft offer several areas for Accountants with Office Accounting: Ability to customise the product to brand it for a specific organisation, such as an accountant, ISV or partner Ability to monitor several people's accounts from the one place and gather updates via an secure online process (through Office Live) Client sends accounts to accountant, continues using them and then the changes are synchronised back from accountant without data loss Run payroll for multiple clients Single Journal entry with VAT that spans multiple dates, customers and...
  • Lots of Partner training (new url) - Licensing 101, Sales 101, Office PerformancePoint, Office Business Applications (OBA), Enterprise Search, SharePoint Services and Server 2007, Office Communications Server 2007, Infrastructure Optimisation (IO) ...

    [updated with a working URL] Partner Licensing 101 – The next one is being held on the 4 th December 2007 This session will equip sales people with a top level knowledge that will enable them to talk to new and existing customers about Microsoft licensing. Target Audience: This session is aimed primarily at sales people from all Partner types, although it is appropriate for all Partner roles whether in Sales, Purchasing or Technical. The course is ideal for new starters looking for a good introduction to Microsoft licensing or just a great as a refresher for those who have taken a break from Microsoft licensing. This session is suitable for people who present technology solutions to customers from a non-technical perspective and need to demonstrate the correct way for customers to purchase. Click Here to register For further information please contact Carla Symonds. Partner Sales 101 - The next one is being held on the 5 th December 2007 - Aim: This session will equip sales people with the knowledge and skills...
  • Visual Studio 2008 and .NET 3.5 Released - MSDN members can download the product and the Express and trial versions are available for download now too.

    I just saw this as Scott's blog while preparing something on SQL 2008 CTP. This is an amazing set of tools now released!! Visual Studio 2008 and .NET 3.5 Released Today we shipped Visual Studio 2008 and .NET 3.5. You can download the final release using one of the links below: If you are a MSDN subscriber, you can download your copy from the MSDN subscription site (note: some of the builds are just finishing being uploaded now - so check back later during the day if you don't see it yet). If you are a non-MSDN subscriber, you can download a 90-day free trial edition of Visual Studio 2008 Team Suite here . A 90-day trial edition of Visual Studio 2008 Professional (which will be a slightly smaller download) will be available next week. A 90-day free trial edition of Team Foundation Server can also be downloaded here . If you want to use the free Visual Studio 2008 Express editions (which are much smaller and totally free), you can download them here . If you want to just install the .NET Framework 3.5 runtime...
  • Where to get lots and lots of information on BCM (Business Contact Manager) 2007

    I found this blog and realised several things. 1) The Brelsford family (no, they are not related) are very good in the small business space. 2) I now have a BCM 2007 hero. Who am I talking about? Bill Brelsford - http://blog.rebarbusinessbuilders.com/about.html - who says "For the past 20 years, I have been working with and for small businesses in a variety of roles." I love BCM and here are some of the things he has written about BCM. It is worth noting that Bill does not just write about BCM, but many things including marketing and many other issues that a small business would face. BCM: Setting Up Marketing Campaigns in BCM Tracking Customer Anniversary Dates in BCM Getting Started Managing Suspects in BCM Small Business CRM It has to be worth a look. ttfn David Technorati Tags: Business Contact Manager , BCM , Small Business
  • Office Accounting Professional 2008 ships in the UK ... download the free Express version, buy or try the Professional version for extra features (Multi user, SQL support, sales order, purchase order etc) and also sign up for online services (Paypal, BACS

    Microsoft Office Accounting Professional 2008 It is finally here!! There are 2 major versions - the free version and the paid for version, plus a number of add-on services you might want to buy too. You can get lots of information at http://www.msofficeaccounting.co.uk/default.aspx and if you are an accountant then the Microsoft Professional Accounting Network is for you ( http://accounting.microsoft.com/mpanuk.aspx ). You can download the Express Version here: You can Download Free Trial here It says about itself: Microsoft® Office Accounting Professional is an easy to use, comprehensive accounting package that works with other Office applications you already know. Easy to learn and use Works just like Word, Excel and Outlook Get started in minutes with wizards that import your data Save time managing everyday tasks Share and reuse data across Word, Excel and Outlook Manage customers, suppliers, employees and stock Pay bills, track expenses, send invoices and bank online Get a complete view of your business Run...
  • Want Office 2007 with a 50% discount? You have until Christmas to upgrade and get a 50% discount with Open Value Subscription

    Again, browsing the small business blog and I thought this was very interesting: Why wait? Upgrade now to 2007 Office and save 50% Until 31 December 2007 you can get a 50% discount off the 2007 Microsoft Office system when you upgrade through the Microsoft Open Value subscription programme. Why do it this way? Because you get a huge discount, you can manage your payments over three years to help your cash flow, you’ll receive a single agreement for all your software licences, and get the benefit of Microsoft Software Assurance, which offers version upgrades and training and partner services. Learn more about the benefits of upgrading here . Microsoft's Small Business Blog : Why wait? Upgrade now to 2007 Office and save 50% ttfn David Technorati Tags: Office 2007 , UK , Discounts
  • There I was talking about Office Business Applications (OBA) and there is training around the UK available

    From the Empower Blog I saw: Office Business Applications (OBA) Technical Briefing This two day technical briefing explores an emerging category of applications, known as Office Business Applications (OBA). It explores the technologies that underpin them, in particular Microsoft Office 2007, Windows SharePoint Services, Microsoft Office SharePoint Services and Open XML. This two-day course is run as a seminar and the labs are provided as a take-away for attendees to go through in their own time. For more information and to enrol, follow the link to the Partner Learning Centre and sign in using your Partner Program login and password. OBA Briefing ttfn David Technorati Tags: Office Business Applications , OBA , Training
  • Where to start to build products that integrate with Microsoft Office

    I came across the OBA (Office Business Applications) web site www.OBACentral.com which has lots of information about nearly 200 OBA solutions. While there is a getting started and "on ramp" information on the site, I found the MSDN site ( Office Integration ) which I like almost as much. Given the prevalence of the Office Platform, assuming it is there and building on it can make life much easier!! Office Integration Need to integrate two or more Office products? Need to integrate Office products with other Microsoft products and technologies? Want to learn about designing and building applications using the Microsoft Office System? This section of the portal provides pointers to resources that will help you build real-world business solutions. Office Business Applications The 2007 Microsoft Office system provides a comprehensive set of servers, clients, and tools to make it easier for enterprises, software vendors and developers to build and deploy a new class of business applications called Office...
  • How to use OCR (Optical Character Recognition) in Office 2007 (using OneNote or a small tool)

    As you know I have been away on holiday and I fly away again tomorrow. While I was traveling I asked my dad to send me a recipe for some scones. He was unable to find the OCR tool in Office 2007, but with the help of OneNote 2007 it was very easy. Paste the image you wish to OCR into OneNote and let it do the rest. I found the answer at OneNote 2007: OCR Rocks this researcher's world | Techwillow where there is more information, but in summary: This is how it works: Take any image of text, paste it into OneNote, right-click on it and select Copy Text from Picture . That's it, you can then paste it anywhere as text. What's more OneNote will automatically OCR and index all your images (if you enable this in the settings) so you can search through your clippings. Now, of course you might not have OneNote, but that does not mean you don't get scanning. As the project at http://www.codeproject.com/office/modi.asp points out, you can use their code and the Office 2007 scanning tools to make it work too...
  • Office Rocker! : Ecma Open XML real world stories

    I don't know how many of you read the Office Rocker blog from Darren Strange ( http://blogs.msdn.com/officerocker ), but I did like this entry given all the recent discussions about Open XML. At the end of the day the discussion is not who's standard it is (ISO, ECMA etc) although there does appear to be a pecking order, but more about what people can do once it is in use. Darren has highlighted some people who are actually using Open XML to extend their business. Ecma Open XML real world stories This afternoon I was presenting at the Office Business Applications architects council with the good looking chaps on the right here. I was talking about some of the stories I've come across from our customers and partners who are using Ecma Open XML in their solutions. I have 4 stories published recently about Ecma Open XML that illustrate what I think are 3 significant categories: 1. Integrated add-in Fractal:Edge have a great visual concept for representing the drill down on data using what they call a...
  • Training for users on SharePoint 2007

    From the SharePoint product team: Greetings, Looking for end user training for WSS 3.0 and MOSS 2007 ? The product team has released the SharePoint End User Training Kit - http://blogs.msdn.com/sharepoint/archive/2007/10/11/sharepoint-end-user-training-kit-now-available.aspx . The SharePoint Server 2007 Training includes interactive demos, videos, and articles. You can customize the training to match your site look and feel or use it as is. The SharePoint End User Training Kit will also have a standalone deployment option, which can be installed on a PC and used by an individual. This version of the kit will be available within the next few weeks. For more information about the kit and instructions on how to obtain it, please go to the end user focused " Get the 'Point " blog. ttfn David Technorati Tags: SharePoint , Training
  • Videos on Office usage - Document Inspector, Excel Templates and formatting, Outlook on the go and enhancing word documents

    I have documented some of these videos before, but I thought I would document them all now - How to use the document inspector - How to find a template for Excel and then customise it for UK dates and currency, change the formatting and more - How to use conditional formatting in Excel - How to use Outlook Web Access and Outlook Anywhere (RPC over HTTP) - How to enhance a document using various things - cover pages, table of contents, pictures, smart art, formatting ttfn David Technorati Tags: Office 2007
  • How to save money when offering licensing to small businesses in the UK at the moment

    [updated to remove some inaccuracies about Susanne's microspeak - sorry Susanne] There are always special offers of some form or another from most companies and Microsoft is no exception (well, except in August when we are still in post financial year clean up :-)). Anyway, the UK SMB Girl aka Susanne Dansey at Westcoast has listed a couple of these.: N-3 Open Value Subscription Offer Promotion ends: 31 December 2007 Programme: OV Subscription Up-to-Date Discount (UTD) is a 50 per cent discount in OV Subscription for the first year invoice for any licence for the current (N) or previous (N-1) version of the selected Small Business or Professional Desktop platform products. For the OVS N-3 promo eligibility for receiving the 50 per cent discount is granted to N-3 versions of Office licences (back to Office 2000). Promtional SKUs are identified on the price list by the word ‘Promo’. Future proofing Microsoft Windows Small Business Server 2003 R2 Here’s a heads up to all Microsoft Partners thinking about licensing...
  • IIS and SharePoint and ISA updates, information and web casts for this month

    This information comes from the Technical Rollup Mail blog which can be found here http://blogs.technet.com/trm/ . I extract the sections and then remove some of the items that don't work for me for ISVs and/or SBSC partners. News 6 new case studies published this month - http://www.microsoft.com/casestudies/search.aspx?ProTaxID=1265&NoDays=30 IIS The Tasty Morsels Found In Dogfood… MSCOM OPS Top 10 Changes In IIS7.0 http://blogs.technet.com/mscom/archive/2007/09/07/the-tasty-morsels-found-in-dogfood-mscom-ops-top-10-changes-in-iis7-0.aspx The .NET Show: IIS 7.0 (Shipping with Windows Vista will be the latest version of Internet Information Services (IIS), which includes a broad collection of features and capabilities that have been anxiously awaited by both developers and IT Pros. Scott Guthrie and Bill Staples describe and demo new features in IIS 7.0. ) http://msdn.microsoft.com/theshow/episode.aspx?xml=theshow/en/episode056/manifest.xml Sharepoint Technologies Correction for last month where we missed...
  • Installing WSS v3 on a Member Server in an SBS Network

    I have spoken before about how to install WSS on the SBS box, so it was quite nice to see the article on how to install on a member server - much simpler to do many less problems. Installing WSS v3 on a Member Server in an SBS Network If you’ve got a member server in your SBS network (especially if that server is a beefy SQL box) it may make sense from a performance standpoint to install Windows SharePoint Services version 3 on the member server instead of directly on the SBS box. This is actually a pretty straight-forward process, but in case you’re not totally comfortable with WSS v3 yet, the procedure is documented below using a combination of a Microsoft e-book and the WSS on SBS instructions Chad came up with for SBS. Installing WSS v3 on a Member Server in an SBS Network | NoGeekLeftBehind.com ttfn David Technorati Tags: WSS v3 , SharePoint , SBS 2003
  • Business Contact Manage 2007 (BCM) with LinkedIn and/or Windows Mobile

    I was reading the Small Business Building Blocks blog and noticed this handy time for BCM and LinkedIn. As many of you know BCM is a favourite product of mine and one that providing the machine has the grunt is an excellent productivity tool. I've been playing around with the LinkedIn toolbar for Outlook . One of the issues that I constantly run into with tools like this is that they are made to work with Outlook contacts but don't always work with Business Contact Manager (BCM). I've had better luck with this add-in than others, so I thought I would post a little about what I have found. If anyone has figured out a better way to address these issues, I'd love to hear from you. The LinkedIn toolbar has a couple of ways to create contacts. One is from the LinkedIn dashboard, when it recognizes a contact in LinkedIn or your e-mail folders that is not set up as a contact. A second way is to use the "grab" button to create a contact from text or an e-mail signature. When LinkedIn creates...

(c)David Overton 2006-18