In order to achieve optimal client-server performance while preserving application functionality, it is important to understand which Access QueryDefs may be converted to Oracle and used as non-updatable Pass-Through Queries, and which QueryDefs are used by the application to maintain (add, modify, delete) data.
By utilizing server side views and procedures instead of Access queries that use linked tables, optimal network and database performance can be achieved. For QueryDefs used to maintain data where linked tables must be employed, it is important to know whether post-conversion performance will be compromised unless the Access QueryDef is reformulated, removing performance inhibiting constructs. (See High-Overhead Query Report).
From the Tools | Migration Tools menu (or shortcut), choose the Build Where-Used List entry.
The Where-Used List Builder stores Form and Report Record Source values and Row Source values specified by List Boxes and Combo Boxes with the Table/Query Row Source Type. The "Update" status of Record and Row Sources is also saved. The Update Status of all Report Record and Row Sources is set to False. The Update Status of Forms that allow Edits, Inserts, or Updates is set to True. The Update Status is set to False for List and Combo Boxes that specify Yes to the Limit To List property and for Graphic controls.
Check the Search Modules box to search for QueryDef occurrences in Form and Global Modules. The following whole word strings are used for the search:
[QueryDef]
"QueryDef"
QueryDef (enclosed by spaces)