Microsoft Access – Find and Replace Issue
In Microsoft Access 2007, the "Search Fields As Formatted" check box checked results in a serious performance hit when a Find is done on a linked Oracle table. Even though the Find is being done on an indexed field, and the Access link to that table is aware that the field is indexed, the Find still does a sequential search through the table. Each record is brought back to the PC to see if it has the desired value. As a result, a value that appears in the 200,000th record will require a significant amount of time (many, many minutes), before it's found. On the other hand, if the "Search Fields As Formatted" check box is unchecked, then the Find operation will only take a few seconds.
I am trying to find a "Registry Hack" that would change the "Search Fields as Formatted" unchecked, versus checked.
Any suggestions?
Software/Hardware used:
Software/Hardware used:
ASKED:
February 18, 2008 6:21 PM
UPDATED:
February 28, 2008 6:12 PM
Answer Wiki:
I experimented with a dummy database and discovered that after turning off the "Search as formatted" option, the option remained off for subsequent searches.
If you are in a form when the search is initiated, you could then create a command button to initiate the search. Use the wizard to create a search action on the Click event and let it set up the DoCmd.FindRecord command line. The default is to set Search as formated to False.
The VBA help topic "FindRecord Method" shows the complete description of the command line options:
expression.FindRecord(FindWhat, Match, MatchCase, Search, SearchAsFormatted, OnlyCurrentField, FindFirst)
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
