Estimated reading time: 3 minutes

Preparing the FRx Report Specification File for Migration

Before completing the FRx migration, you will likely need to find your FRx Report Specification file, convert it to an MS Access file type, and release any database password permissions.

Finding the FRx Report Specification File

To Do

Step 1: Open FRx Report Designer. Under the Company menu choose Information. Choose your company and write down the Specification Set used.

Step 2: Go back to the Company Menu and select Specification Sets. Then, choose the specification set noted above and write down the Location of the .f32 file.

Converting the .F32 file to an MS Access .MDB File

To Do

Step 1: Copy the .F32 file to a temporary work directory on your local machine. Rename the file extension to .MDB, then open the file in MS Access.

Step 2: Enter the database password (contact your implementor for the password). Click "Save As," then click OK on "Invalid Password" message. Re-enter password.

Step 3: Click through all "missing or broken references" messages.

Step 4: Select a path and provide a new file name, for example "FRxDemo_Interject.mdb." Click save.

Step 5: Click OK on the “Not a valid password” error and re-enter password. Note: You will be prompted to do this twice. Then enable content.

Step 6: Close MS Access.

Remove the Database Password

Note: This requires the database to be opened in "Exclusive" mode.

To Do

Step 1: Open MS Access and choose to "Open Other Files."

Step 2: Choose "Browse."

Step 3: Locate the file you renamed, select the drop-down next to "Open," and select "Open Exclusive."

Step 4: Under File, choose "Unset Database Password."

Step 5: Re-enter the password, then close MS Access

You have now converted the .F32 file to an .MDB and removed the password requirement. Proceed now to the FRx Migration page.