Attempting to repair a damaged or corrupt .APR file
You determine that your IBM Lotus Approach .APR file is either damaged or corrupt. It either generates an error when you attempt to open it or it will not open at all. You rule out all other causes. Additionally, if you open the data file (.DBF) by itself, all the data is present and is accessible.
You would like to attempt to salvage the .APR. How can this be accomplished?
You can often salvage all or part of an .APR file by importing it into a .DBF file. However, this procedure is a last resort and the best practice would be to restore the file from a backup, prior to any corruption or damage. Also, Global Script objects will not be included in the import.
For more information about this, refer to Document #1178529, "Importing an .APR File Doesn't Import Scripts from the Globals Object."
TO IMPORT AN .APR FILE INTO a .DBF FILE
1. In Approach, from the File menu, choose File --> Open --> Files of type --> dBASE IV (*.DBF).
2. Open the .DBF file associated with the damaged .APR file. For example, an .APR file named SALES.APR will usually have a .DBF file named SALES.DBF associated with it. For customers using multiple .DBF files (a relational database) in a single Approach application, open the main .DBF file and recreate the joins to the other related databases.
3. Opening the .DBF file creates a default .APR file with the same file name as the .DBF. The default .APR file contains one default form and one worksheet. Once the default .APR is created, switch to Design mode.
4. From the File menu, choose Import Approach File --> damaged .APR file --> Open.
5. Correctly map the fields in the original .APR file to the newly created .APR file in the Import Approach File Setup dialog box. For customers with multiple databases, it is only possible to map a portion of the fields in the original .APR file, unless the join is recreated before import. Once the fields are mapped, click OK.
6. Once you determine that the import was successful, delete the generic form and worksheet that are created by default.
7. From the File menu, choose Save As, and save the new .APR and all associated databases with a new name.
NOTE: You may want to keep the old files until you determine that the new file is complete and behaving as desired. It's possible that the damaged element may be imported with the rest of the file and the problem may recur. In this case, you will want the originals around for further troubleshooting.
Discussion forum for additional help
Discuss this information with your peers or post a question in the Lotus SmartSuite customer discussion forum.