Approach User Support homepage Approach User Support
Answers to Frequently Asked Questions about Lotus Approach
Examples LotusScripts
Example databases
Links to other Lotus Approach support services

[Return to contents]

.oyz index files

Last updated: 27 Mar 2004 by XpertSS.com

If you find a file with a .OYZ extension/type in the folder or directory where your databases are stored (.DBF extension/type) this indicates that the .ADX (SmartIndex) file for that database is corrupt.

Approach has created the .OYZ file to allow access to the database but the results may not be reliable. In fact, since the .OYZ reverts the affected field names to their dBase default length and format, your scripts may not work at all! And you may be asked to "map fields" when opening your .APR file due to the field name changes.

To get rid of this problem, you need to delete the .oyz AND then either repair or delete/rebuild the matching .adx file.

IMPORTANT: BEFORE YOU DO ANYTHING, make sure you read the following two articles in the FAQ:

'Deleting and recreating index files (.adx)' which outlines this procedure and implications in more detail, and gives more details about .adx index files.

'Repairing corrupt index (.adx) files' which outlines a widely affirmed method of rebuilding a .adx without losing any information. However, there is no guarantee that this procedure will work in every situation.

[Return to contents]

© Copyright, JohnBrown, Trademarks, Disclaimer, Acknowledgements.