Acute Data Systems

Failed to Open Rowset, Unable to access Database or field…, or Crystal Report Database is in use by another user when printing graphical forms or Crystal reports in Sage 100

Description

“Failed to Open Rowset”, “Unable to access Database or field…”, or “Crystal Report Database is in use by another user” when printing graphical forms or Crystal reports

Disclaimer

Sage Customer Support does not provide assistance for issues related to third-party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions.

Cause

This is a generic error that indicates that Crystal Reports cannot access the data, usually because of missing files or insufficient permissions.

Resolution

Note: These procedures require proficiency with Crystal Reports. Sage Customer Support is not responsible for assisting with the use of non-Sage Software products. For assistance, please see that product’s Help for instructions, or contact their technical support department.

  1. If using Sage 100 ERP Advanced (MAS 200), check to see if the CS ODBC driver was mistakenly activated:
    1. Open Library Master, Main, User Maintenance
    2. Click Preferences tab, and clear the Enable CS ODBC Driver check box
    3. Open Library Master, Set Up, System Configuration
    4. Click ODBC tab, and clear the Enable C/S ODBC Driver check box.
    5. If the system is supposed be configured to use the C/S ODBC driver, see the following article to troubleshoot the issue: How to install and configure the client server ODBC driver for Sage MAS 200
  2. Verify that the share point has correct permissions on the network.
  3. Verify that the user has sufficient permissions in ODBC security. For more information, see How to set up ODBC security for users, companies, tables and fields
  4. Obtain the specific error. Click the Form or Designer button, and refresh the report from within Crystal Reports. A more specific error should occur. Search the Sage knowledge base for the specific error.
    Note: Crystal Reports must be installed to perform this step.

If no specific error can be obtained, perform the following:

  • Create a new form code with no customizations. If the form refreshes successfully, determine what changes to the original form caused the error.
  • Reset the SQL statement.
    1. Click the Form or Designer button to open the report in Crystal Reports.
    2. On the Database menu, click Show SQL Query.
    3. Click the Reset button.
    4. Save and close the report.
  • If a UDF file was added to the form, verify that the link is correct.
    • Verify that the report has only one left-outer join. Create a subreport for the UDF if necessary.
    • Verify that the correct fields are linked.
  • Replace the data dictionary files for the module that is being accessed by Crystal Reports.
  • If the error still occurs, multiple versions of Crystal Reports may be installed. Uninstall all but the version that is compatible with your installed version of Sage MAS 90 or 200.
    • Crystal Reports 10: Sage MAS 90 and 200 4.10 – 4.50
    • Crystal Reports 8.5: Sage MAS 90 and 200 4.05 and earlier
    • Crystal Reports 9 is not compatible with any Sage MAS 90 or 200 version and must be uninstalled.

Support

If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.

Crystal Reports
Request Support