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.
February 18, 2008 6:21 PM
February 28, 2008 6:12 PM