Access GBV: Saving SQL View

Menu Expand/Collapse Menu
In the _Xref database built during data collection, the SQL view of queries is stored. This becomes important when working with legacy databases where objects have been deleted or renamed. The query designer will corrupt the SQL making interpretation difficult. Preserving the original SQL allows the developer to see the original intent of the query. Used with the UltraEdit tools makes query interpretation a snap.
Access Glassbox Views