Queries are not displaying in the Object Explorer 'Query' tab (4309214)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

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.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title