Error: "Runtime error 1004 - General ODBC error"

You are printing a report, which needs to open in Excel using either ODBC or SMART Reports.

The error could be related to the company selections or to the MS Office package, which is currently installed.

Step 1: Update the CBLCONFI file and rebuild data files

• Access the system folder in File Explorer
• Locate the file CBLCONFI
• Open the file with Notepad
• Add the command line VERSION_V 5 in the file as in the example below:

• Access the Payroll system
• Rebuild the company files. Click here for steps to rebuild the company files

Step 2: View Permissions and "Apply changes"

• For ODBC reporting:
  • Access any payroll company
  • Click Utilities > VIP ODBC Configuration
  • Click Permissions
  • Start with the 1st company
  • Click the user name (the user running the report)
  • Make sure that all the permission blocks are ticked
  • Repeat the above steps for all the companies (click the user name every time as it defaults to the top name)
  • Once completed, "Apply Changes"
  • Open the report and ensure that the correct companies to which the user has access to is selected or included
  • Check the report data 

• For SMART reporting:
  • Follow the ODBC Solution, if the problem persists;
  • Open SMART and click setup
  • Make sure that the correct companies are under "selected companies"
  • If not – remove the incorrect company
  • Run report again

Step 3: Review version of Office package

If the error still comes up, close all programs, open a new Excel workbook then follow the steps below:

• Excel 2010 > Click on File > Help > make sure the package is on 32-bit; if it’s on 64- bit, your IT department will need to uninstall office professional and reinstall the 32-bit version of office with all features and add-ins
• Excel 2013 > Click on File > Account > About Excel > make sure the package is on 32-bit; if it’s on 64-bit your IT department will need to uninstall office and reinstall the 32-bit version of office professional with all features and add-ins
• Excel 2016 > Click on File > Account > About Excel > make sure the package is on 32-bit; if it’s on 64-bit your IT department will need to uninstall office and reinstall the 32-bit version of office professional with all features and add-ins
• Excel 365 > Click on File > Account > About Excel > make sure the package is on 32-bit; if it’s on 64-bit your IT department will need to uninstall office and reinstall the 32-bit version of office professional with all features and add-ins