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…

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 …

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…

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…

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…

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes and/or images to Word in a structured fashion, whether as a one-off solution or as a product of iterating through a list/database. E…

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…

Introduction & Background..   From the unexpected lottery winnings and Nigerian princes wanting to share their millions to beautiful overseas women who can’t wait to propose marriage, scammers will use just about any angle imaginable to get you to reach into your pocket and part with your cash. They are relentless, criminal fraudsters. Being the heartless fiends they are, they don’t di…

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: LVL is …

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 …

The latest version of Apple’s macOS is now finally dropping support for 32 bit apps. macOS High Sierra started the change by warning existing 32-bit are not optimized for the Mac. If you have any applications that are still 32-bit, then you need to upgrade, replace or remove these old applications before upgrading to Catalina, as they will no longer run. If you feel that your apps are too im…

First, let me start by saying that this is not an article to learn about the concept of Switch–Case in programming. This article assumes that you have programming/scripting experience and are a user of the AutoHotkey language or, at the very least, interested in it. If you are new to AutoHotkey , my Experts Exchange article will get you started with it: AutoHotkey - Getting Started Wheth…

I will start by assuming that the reader is familiar with Bitlocker and even MBAM. This article is for you admins that already deploy and manage Bitlocker or those who are about to do so in the near future. Let me ask you this: Have you noticed, that there are dozens of standard, built-in GPOs that can be used to configure Bitlocker, while there is not a single GPO that does actually enable Bitlocke…

Overview Experts Exchange keeps two types of ranks for every member: Member rank which is your overall rank based on the total of all the points you have earned compared with other members, and Topic rank which is a set of ranks for every topic in which you have participated, again compared with other members. How to do it It’s a little convoluted, but to get to your rankings…

This article is meant for system administrators, who try to apply the principle of least privilege when it comes to Active Directory. I find it relevant because the usual way of using the delegation of control wizard cannot satisfy the need for least privilege and we need to use a largely unknown method instead, which will be described here. Imagine you have applied bitlocker to all your machines and …

Part 1: Considerations or “why should I use that?” Let me start by listing what other methods there are and why I would not recommend using them. There is numerous 3 rd party software for this intent, but most of it costs money that you may save using what’s built-in. Even free remote control software like UltraVNC has some challenges: how do we deploy it, maintain it, ensu…

DNS offers a variety of information about public organizations servers, such as IP addresses, server names, and server purposes. Let’s take a closer look at how to perform DNS enumeration. Interacting With a DNS Server 1 2 > host -t ns example.com           # -t : type , ns: dns > host -t mx example.com            # mx : mail server …

Well we all know the situation...we have/come across an older version of an Access database and we just can't  get our hands on the data....we try to import the data only to get this "nice" info  Till now the only solution was to hunt down older copies of Microsoft Access to see if it can support the importing for our database... Well, this is partially over...with this littl…