[AccessD] Search query for fileds used

If you change the options to allow viewing of Hidden and System tables
and then make a query using the MsysObjects and MsysQueries tables you
can get a lot of info

SELECT MSysObjects.Name, MSysObjects.Type, MSysObjects.Id,
MSysQueries.Attribute, MSysQueries.Expression, MSysQueries.Name1,
MSysQueries.Name2
FROM MSysObjects INNER JOIN MSysQueries ON MSysObjects.Id = MSysQueries.ObjectId
WHERE (((MSysObjects.Type)=5));


GK

On Thu, Aug 5, 2010 at 11:03 AM, Mark A Matte <markamatte at hotmail.com> wrote:
>
>
> Hello All,
>
> I need to search the queries in an MDB and find which ones use certain fields?
>
> Thanks,
>
> Mark A. Matte
>
> P.S...I can use any version between 97 and 2007
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com