[AccessD] Search query for fileds used

Gary Kjos garykjos at gmail.com
Thu Aug 5 11:43:25 CDT 2010

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,
FROM MSysObjects INNER JOIN MSysQueries ON MSysObjects.Id = MSysQueries.ObjectId
WHERE (((MSysObjects.Type)=5));


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

More information about the AccessD mailing list