Cannot open database error when generating an FRx report

Article ID: 865793 - View products that this article applies to.
Microsoft Business Solutions-Axapta 3.0 is now part of Microsoft Dynamics AX 3.0. All references to Microsoft Business Solutions-Axapta and Microsoft Axapta pertain to Microsoft Dynamics AX.
Expand all | Collapse all

TechKnowledge Content


Can't open database occurs the second time an FRx report is generated using a different reporting date.


The FRXSYS2.MDB file has been corrupted.


1. Restore the file from backup.

2. If the problem persists, see Knowledge Base Article - Recreating the FRXSYS32.MDB File in FRx.

Note - If your reports are stored on a NT server, also check to make sure that Opportunistic Locking has been disabled. If it is enabled, this could be the cause of the file corruption.

For more information about Opportunistic Locking, see Knowledge Base article .

This article was TechKnowledge Document ID: 6164


Article ID: 865793 - Last Review: July 20, 2011 - Revision: 3.0
  • Microsoft Business Solutions for Analytics–FRx 6.7 Desktop
  • Microsoft Dynamics GP 9.0
  • Microsoft Business Solutions–Great Plains 8.0
  • Microsoft Business Solutions–Great Plains 7.5
  • Microsoft Dynamics SL 6.5
  • Microsoft Business Solutions–Solomon 6.0
  • Microsoft Dynamics AX 4.0
  • Microsoft Dynamics AX 3.0
  • Microsoft Dynamics NAV 4.0
  • Microsoft Business Solutions–Navision 3.70
  • Microsoft Small Business Financials 9.0
  • Microsoft Business Solutions Small Business Financials North America Edition 8.0
  • Microsoft Business Solutions Small Business Manager 7.5, when used with:
    • Microsoft Business Solutions for Analytics–FRx 6.7 Desktop
    • FRx Financial Reporter 6.5
  • FRx Financial Reporter 6.5
kbnavisionfrx kbsolomonfrx kbsmallbusinessfinancialsfrx kbgreatplainsfrx kbaxaptafrx kbmbsmigrate KB865793

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from