Error message when you apply a service pack to Microsoft FRx: "ActSys32.mdb Not Upgraded: The ActSys32.mdb file was not upgraded in the following directory/directories"

Article ID: 848386 - View products that this article applies to.
Expand all | Collapse all

On This Page

Symptoms

When you apply a service pack to Microsoft FRx, you receive the following error message:
ActSys32.mdb Not Upgraded: The ActSys32.mdb file was not upgraded in the following directory/directories. You will need to reinstall this Service Pack.

Resolution

To resolve this problem, use one of the following methods.

Method 1

Verify that the FRx32.cfg file contains the following section:
[SYSDATA]
To do this, follow these steps:
  1. Open the FRx32.cfg file by using Notepad. The FRx32.cfg file is located in the Microsoft FRx program folder.
  2. Verify that the SYSDATA section exists. If this section does not exist, add the SYSDATA section.
  3. Verify that the following line exists:
    Directory=
    If this line does not exist, it must be added after the SYSDATA section. This line must contain the Universal Naming Convention (UNC) path of the FRx\SysData folder. This path must include a backslash after SysData.
  4. Save the file, and then close the file.
  5. Start the Microsoft FRx service pack installation again.

Method 2

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
Restore the correct registry settings for Microsoft Jet 3.x. To do this, follow these steps:
  1. Click Start, click Run, type regedit, and then click OK.
  2. Locate the following registry key:
    HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\ISAM Formats
  3. Right-click ISAM Formats, point to New, and then click Key.
  4. Rename the newly created key as Jet 3.x.
  5. Click the Jet 3.x key, and then insert the following values on the right side of Registry Editor.
    1. Right-click in a blank area on the right side of the Registry Editor window, point to New, and then click Binary Value. Type CreateBBOnExport in the Name box, and then type 00 in the Value field.
    2. Right-click in a blank area on the right side of the Registry Editor window, point to New, and then click String. Type Engine in the Name box, and then type jet 3.x in the Value field.
    3. Right-click in a blank area on the right side of the Registry Editor window, point to New, and then click Binary. Type IndexDialog in the Name box, and then type 00 in the Value field.
    4. Right-click in a blank area on the right side of the Registry Editor window, point to New, and then click DWORD. Type IsamType in the Name box, and then type 0x00000000 (0) in the Value field.
    5. Right-click in a blank area on the right side of the Registry Editor window, point to New, and then click Binary. Type OneTablePerFile in the Name box, and then type 00 in the Value field.
  6. Click File, and then click Exit.
  7. Verify that both the Regsvr32.exe file and the Msrd3x40.dll file are in the Windows\System32 folder. If these files are not located on the current workstation, they can be copied from another workstation.
  8. Click Start, click Run, type Regsvr32.exe C:\Windows\System32\Msrd3x40.dll, and then click OK.

Method 3

When you install the service pack, point to the local SysData folder.

Note If the local SysData folder does not exist on the workstation, you cannot use this method unless you create a local copy of the current SysData folder. We recommend that you create a copy of the SysData folder only as a temporary workaround.

To point to the local SysData folder, follow these steps:
  1. Verify the path of the current Microsoft FRx SysData folder. You can do this from the Microsoft FRx Report Designer Control Panel. To do this, follow these steps:
    1. Click Admin, and then click Organization.
    2. Click SysData. The path of the shared SysData folder is located in the Current location field. Note this path because you will need this path in step 4g.
  2. You can change the SysData folder path in this window. However, we recommend that you modify the FRx32.cfg file that is located in the FRx 6.7 code folder. To do this, follow these steps:
    1. Right-click the shortcut that you use to start Microsoft FRx, and then click Properties.
    2. Click the Shortcut tab.
    3. Click Find Target. The FRx code folder opens.
    4. Locate and then double-click the FRx32.cfg file.
    5. If you are prompted to select a program to open the file, click Select the program from a list, and then click OK.
    6. Click Notepad, click to clear the Always use the selected program to open this kind of file check box, and then click OK.
    7. Modify the SysData path that is listed on the “Directory=” line to point to the local SysData folder.

      Note By default, the location for the SysData folder is as follows:
      C:\Program Files\FRx Software\FRx 6.7\SysData
      The FRx SysData folder may be in a different location. If you have to locate the SysData folder, click Start, click Search, click All Files and Folders, type SysData in the search window, and then click Search. If multiple SysData folders are found, contact the system administrator to determine the correct folder to use.
    8. On the File menu, click Save.
    9. On the File menu, click Exit.
  3. Install the service pack by performing the steps that are outlined in the release notes for the service pack. To obtain the release notes for each service pack, visit one of the following Microsoft Web sites, depending on if you are a Partner or a Customer:
    Partners
    https://mbs.microsoft.com/partnersource/products/GreatPlains/downloads/servicepack

    Customers
    https://mbs.microsoft.com/customersource/support/downloads/servicepacks
  4. After the service pack is installed, update the SysData path in the FRx32.cfg file to point to the shared SysData folder. To do this, follow these steps:
    1. Right-click the shortcut that you use to start Microsoft FRx, and then click Properties.
    2. Click the Shortcut tab.
    3. Click Find Target. The FRx code folder opens.
    4. Locate and then double-click the FRx32.cfg file.
    5. If you are prompted to select a program to open the file, click Select the program from a list, and then click OK.
    6. Click Notepad, click to clear the Always use the selected program to open this kind of file check box, and then click OK.
    7. Modify the SysData path that is listed on the “Directory=” line to point to the shared SysData folder that you noted in step 1b.
    8. Click Save.

Properties

Article ID: 848386 - Last Review: September 25, 2012 - Revision: 5.0
Applies to
  • Microsoft Business Solutions for Analytics–FRx 6.7 Desktop
  • Microsoft Dynamics GP 10.0
  • Microsoft Dynamics GP 9.0
  • Microsoft Business Solutions–Great Plains 8.0
  • Microsoft Dynamics SL 6.5
  • Microsoft Business Solutions–Solomon 6.0
  • Microsoft Dynamics AX 4.0
  • Microsoft Dynamics AX 3.0
  • Microsoft Dynamics AX 3.0, when used with:
    • FRx Financial Reporter 6.5
  • Microsoft Dynamics NAV 4.0
  • Microsoft Business Solutions–Navision 3.70
  • FRx Financial Reporter 6.5
Keywords: 
kbexpertiseinter kbexpertiseadvanced kbtshoot kbsmallbusinessfinancialsfrx kbnavisionfrx kbgreatplainsfrx kberrmsg kbaxaptafrx kbprb kbsolomonfrx kbmbsinstallation kbmbsmigrate KB848386

Give Feedback

 

Contact us for more help

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