Return
-
Title
Queries are not displaying in the Object Explorer 'Query' tab -
Description
After successfully connecting to an Access database (accdb), the tables display correctly in the Object Explorer. However, on clicking the 'Query' tab, nothing happens and no queries (existing in the database) are shown. On checking the ExceptionTrace.log, the following error is shown:
"System.NullReferenceException: Object reference not set to an instance of an object.Stack trace:at Quest.Toad.Odbc.Scheme.QueryList.QueryListTrl.get_GenerateData()at Quest.Toad.Trl.CachedTrl.get_Data()at Quest.Toad.Odbc.Scheme.QueryList.QueryListTrl.GetTrlCount()at Quest.Toad.DatabaseBrowser.LeftListControl.ReadCount(CountState data, Int32& totalCount, Int32& count)" -
Cause
Many invalid queries in the Access database -
Resolution
Within MS Access, correct or remove any invalid queries. Once all invalid queries have been removed, Toad will display the valid queries in the Query tab.