Access 2016 – Could not find installable ISAM [Solved]

Here’s a quick tip for everyone that uses Microsoft Access with dBase queries and it’s getting the error “Could not find installable ISAM” after upgrading to Access 2016.

To solve this you need to install 2 hotfixes for Access 2016:
KB4018338 (Microsoft Catalog)
KB4011143 (Microsoft Catalog)

After installing both updates, restart the machine and you’re done!

MDT – Drivers & Selection Profiles –WMI Query Error

This week I’ve started to create a new Deployment Share and using Selection Profiles to install drivers.
After creating the Selection Profile for each model, I’ve started to change the task sequence where I’ve disabled the default “Inject Drivers” pass and created new ones.

For this, I’ve created a pass for each model and add a conditional install.based on a WMI query for model.

After this, when testing the new task sequence, I was always getting the above error.
Something look to be wrong with my WMI query but could find out why!

A lot of troubleshooting later, and really with some luck, I copied the query to a notepad and for my surprise, I finally got the problem!

Because I’ve copied the WMI query from a website, when I pasted it it came out with a wrong format. Basically, the double-quotes were in a wrong format!

So…the simple resolution?
Instead of copying the WMI query, just write it yourself and…your done!

Hope this helps! :)

LDAP Queries - Filtering Computer Accounts Service Pack Level

When managing a large environment, it can be sometimes difficult to get all your machines up-to-date.
If you don't have the right tools to get the job done, due to financial restrictions for example you may use some quick and easy ways to get some information you need about how's your environment.

In this case, I'll show how to get the a Microsoft Windows operating system service pack level.
Besides the importance of being up-to-date, if you have some kind of Microsoft Enterprise/Premier support, it's really important to level up your service pack to a supported level.
For example, Microsoft Windows 7 RTM (without any SP) support ended on April 9, 2013.

To get the information, there's a really simple way to do it if the target machines are domain joined.

So, here are the steps:

1. Open the "Active Directory Users and Computers" mmc
2. Then, go to "View" -> "Filter Options"
3. Select "Create custom filter:" and click on "Customize"
4. Click the "Advanced" tab
5. Copy and paste one of the queries below depending on what your looking for and click "OK"
6. Now your mmc will only show computer account that match your query

Queries

Windows XP without any service pack installed
(&(operatingSystem=Windows XP Professional)(!operatingSystemServicePack=*)))
 
Windows XP with service pack 1 installed
(&(operatingSystem=Windows XP*l)(operatingSystemServicePack=Service Pack 1)))

Windows XP with service pack 2 installed
(&(objectCategory=computer)(operatingSystem=Windows XP Professional)(operatingSystemServicePack=Service Pack 2))


Windows 7 without any service pack installed
(&(objectCategory=computer)(operatingSystem=Windows 7*)(!operatingSystemServicePack=Service Pack 1))

Windows 7 with service pack 1 installed
(&(objectCategory=computer)(operatingSystem=Windows 7*)(operatingSystemServicePack=Service Pack 1))

Finding Disabled User Accounts on Active Directory

For working purposes I needed to find all user accounts disabled on our domain and move them to a different Organizational Unit (OU).

To do that without scripting and simply using MMC, follow this tips:

• Open your MMC
• Navigate to Active Directory Users and Computers
• Select View -> Filter Options
• Then select Create Custom Filter and click Customize
• Select the tab Advanced
• For the LDAP query, type useraccountcontrol:1.2.840.113556.1.4.803:=2
  
  

• Click OK and OK again

The MMC will refresh and now for every OU with user accounts (objects) you'll only see the Disabled User Accounts.

To disable the filter just click agar in View -> Filter Options and select the option "Show all types of objects"