Overview
You may be getting the error: "The Microsoft Jet database engine cannot find the input table or query 'Updates'. Make sure it exists and that its name is spelled correctly" when running a Missing Patches scan.
Solution
As per the article Missing Patch Detection for Windows in GFI LanGuard, LanGuard uses two engines to detect missing patches:
- Windows Update Agent - for Microsoft updates.
- LanGuard Patch Engine - for third party apps and Windows/Microsoft patches
The LanGuard Patch Engine uses the Patch Management Database (lanss_12_patchmngmt.mdb), located by default at C:\ProgramData\GFI\LanGuard12\PatchManagement. This error would suggest an issue with the .mdb file. In order to troubleshoot this issue, please apply the following steps:
- Please update LanGuard manually using the article Updating LanGuard Server Manually When Unable to Get Current Updates or Agents Do Not Pull Latest Definitions from Server. Run the Missing Patches scan to verify if the issue is resolved.
- If the issue persists, repair LanGuard as per the article Fixing GFI LanGuard Broken Installation or Failed Upgrade.