[AccessD] Can't find Query

[Stuart McLachlan]

Very good point!   

-- 
Stuart

On 12 Nov 2015 at 16:28, McGillivray, Don wrote:

> 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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>