Security Compliance

Unable to export Patch Manager data to a Microsoft Access database

This article addresses an error that displays when you export Patch Manager data to a Microsoft Access database.

First published date

10/22/2018 9:15 PM

Last published date

10/22/2018 9:15 PM

Overview

If you select the Export to Microsoft^® Access Database (*.mdb) option when exporting data from the Patch Manager console, the export fails and the console returns the following error message.

Error Message:
Failed to export. Error Code: 1 Message: Incorrect function

Product section

Patch Manager

Cause

Microsoft .NET Framework does not support exports to Access by default. To support this functionality, Microsoft requires the Access Database Engine 2010 Reditributable pack or the 2007 Office System Driver on the system generating the export.

Resolution

Perform one of the following procedures:

Select an alternative export file type.
Install the 2007 Office System Driver: Data Connectivity Components on all Patch Manager systems that generate Access exports (© 2018 Microsoft Corporation, available at http://www.microsoft.com , obtained on January 11, 2018).
Install Microsoft Access Database Engine 2010 Reditributable pack on all Patch Manager systems that generate Access exports (© 2018 Microsoft Corporation, available at http://www.microsoft.com , obtained on January 11, 2018).
For example, if Patch Manager is exporting the data from scheduled reports, install the Redistributable pack on the Patch Manager server running the reports.
If you are exporting the data from a Patch Manager console, install the Redistributable pack on the server running the console.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.