It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. We love the accolades. We love to be seen as the digital white knight who fixed the server, the computer, the email, and anything else that life depends on. We love it so much, we some…

This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the following software: Windows Small Business Server 2003 (SBS 2003)Windows 2008 Server or Windows 2008 R2 ServerExchange Server 2010Microsoft Office Filt…

On numerous occasions I was seeing questions pop up that involved Exchange 2003 and problems getting iPhones / Windows Mobile phones and now more recently, iPads, to work with Activesync, so after answering several questions, I decided to write the following article to assist others in answering their problems, covering all the possible scenarios that I had faced when tackling these proble…

HOW TO: Shrink a VMware Virtual Machine Disk (VMDK) in 15 minutes In my previous Experts Exchange Articles (http://www.experts-exchange.com/ARTH_1864316.html?arthOrderBy=3&arthSort=1#arth), most have featured Basic and Intermediate VMware and Virtualisation Topics. If you would like to read my Basic VMware articles, they are listed here for …

Known by most simply as Google’s version of web-based email, Gmail has quite a fascinating background. Released to the public in 2004, Gmail was actually in beta for five years. This means that users have only known the official Gmail for a little more than two years, except for those users who immediately turned on the “Back to Beta” feature as soon as the email service switched out of its i…

There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover the most common ones here. Exchange 2007 Service Pack There was an issue with repeated password prompts that was resolved by installing Rollup 9 for Exchange 2007 SP1…

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of course nobody would store client passwords in clear-text, but many of the attempted solutions (message digests, encryption, etc) are little …

Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dictionary is a powerful and versatile class, and is useful for many programming tasks. While VBA's native Collection class offers functionality that is in many respects similar to the Dictionary, the D…

I've replied to several members this week (in both private messages and group discussions) who asked the question in the title of this article. I suspect more of the same may be coming, so rather than posting the same answer each time, I decided to write this article, and will simply send along its link to members when the question is posed. What they're talking about is this: …

Background: In Access 2007, Microsoft did away with the database window and replaced it with the Navigation Pane, frequently referred to as the NavPane, or more appropriately, the NavPain [sic]. I really like the search feature of the NavPane, but I keep seeing forum posts asking how to resolve the problem that no matter how you hide it, it will not remain hidden when you import or link…

In a previous article here at Experts Exchange , I explained how to install Microsoft Office Picture Manager 2010 with Office 2013. This was necessitated by Microsoft's removal of Picture Manager from the Office 2013 suite — it had been included in Office 2003, Office 2007, and Office 2010. Many users, this author included, had high hopes that the folks at Microsoft woul…

Would you like to write a technical article and have it published?  Great! Welcome to our world! This is my tutorial on how to increase the odds of getting your article published and with honors, and is full of witty one-liners from writing around twenty and editing around a hundred articles.  This ​Top 10 Ways To Write Rock Star Articles is not the official opinion of Experts Exchange.  It i…

Contributing experts here can answer all kinds of technical questions.  In return for our time and expertise we get some pretty cool stuff, such as T-shirts, polo shirts, backpacks, bathroom bags (wonder whose idea that was?), these mythical things called 'points' and 'ranks', and the more deserving are awarded Most Valuable Expert (MVE) or a trophy or three.   But we also have j…

Introduction: Have you ever been given the advice NOT to use domain functions inside queries?  I have, and I have repeated that advice over and over again; why?  The main reason is that this process is inherently slow. But what if you absolutely need that value in your dataset?  I recently ran into this problem, and no matter what I tried, I could not get a particular field into a dataset an…

Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and removed the user interface for creating commandbars. This resulted in a common misconception that all CommandBars have been deprecated …

Personal disclaimer Before going any further I want to make it clear that the contents of this article express my personal opinion. You are perfectly free to disagree and I respect your right to do so. That said, you are highly unlikely to convince me that learning C is a valuable path to learning C++ so whilst I do appreciate any comments you might have on my article, posting long-winded arguments to th…

A watermark is an identifying image or text pattern in confidential documents that indicate information such as who owns the document and who authored it. It leaves an impression of professionalism to business PDF files and also prevents against other parties passing off your work as their own. A Watermark should be added to all the critical documents, especially in an invoice.  After selling an…

How to Check Mailbox Corruption in Exchange 2013/10/07 Server Microsoft Exchange Server is used to store all Emails, Contacts, Notes, Journals and other user details in EDB format. However, Exchange Server is vulnerable to corruption and other issues so users sometimes need to repair the corrupted files. But, the first step is to identify whether or not there is any corruption in the …

There are lots of concerns when moving to a new platform which can be quite daunting for an admin department, so there are quite a few things to consider when moving to Office 365. Here we describe some important information that must be considered before making a transition.  The following critical items can be useful to any IT department, technical staff or regular non-technical busine…

It seems these days I’m writing a lot of VBScript scripts. My scripts are often interacting with a MySQL database but could be doing other things as well, such as connecting to workstations to push files. One of the biggest problems with scripts that need credentials is how to store the password in these clear text files. I’ve come up with a reversible encryption to store the password. The script belo…

Technologists and Researchers alike are discussing how blockchain technology is the next huge thing crosswise over businesses from the fund to retail to even medicinal services.  So let’s learn what is blockchain? Or where is the blockchain stored? And as well what does unconfirmed transaction mean on blockchain? All in brief. Blockchain explained: The Blockchain t…

Are you facing “No Named Ranges” error when importing contacts from Excel to Outlook? Then, this guide will definitely help you to resolve the No Named Ranges error when importing to Outlook in a proper way. Microsoft Excel spreadsheets are used by professionals as well as home-users to maintain data in tabular form. Contacts are one of the common things that usually maintained in Excel…

Gmail Labels allow a user to manage Google account emails by organizing inbox in a proper way. Most of the message processing is done automatically after setting up labels as they make it easier for a user to skim through the inbox. Basically, labels provide a way to categorize Inbox mail folders. By using labels one can keep a Gmail inbox neat and well-organized. But sometimes a user needs to Mig…

There are situations in which Exchange database becomes dysfunctional because of improper system shutdown, hard drive failures, sudden Server breaks down, etc. These circumstances can cause all business activities to go into an inactive state. In addition to this, it increases the chances of Exchange EDB file corruption and makes it completely inaccessible. Another possible issue is that a use…