[AccessD] Can't find Query

[McGillivray, Don]

Hi Bob,

Check the SQL behind the query.  It's possible that the "query" showing in the design view is really embedded SQL with an alias.  

Something like:

SELECT qryFooBar.* FROM (SELECT MyTable.* FROM MyTable WHERE MyTable.MyColumn = 'FooBar') as qryFooBar;

In the design view this will appear as a table called "qryFooBar", but that query won't exist among your defined queries in the DB container.

Don

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
Sent: Wednesday, November 11, 2015 9:19 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Can't find Query

Hello to the List,
I am trying to troubleshoot a query that returns an error "Record Deleted".
When viewing in design view, I see the source of the query is another query and some tables.
BUT, when looking at the Nav pane, I can't find the source query I see in the design view. IOW it seems like it is hidden.
Though when I check if "hidden" objects can be viewed, the option is set to view them.
Is it possible that someone deleted it ?
Where is it?

TIA
Bob


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com