[AccessD] Can't find Query

Bob Heygood accesspro at gmail.com
Sat Nov 14 10:26:28 CST 2015


No not a sys object.
Thanks for responding.

Bob


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Wednesday, November 11, 2015 3:05 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Can't find Query

Try "Show System Objects" as well.   If it's been named starting with "msys"
or "usys", it will 
not show up without that switch as well.


On 11 Nov 2015 at 9:19, Bob Heygood wrote:

> 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



More information about the AccessD mailing list