Hello,

I was wondering if there is anyway to be able to identify or monitor changes made to a query.

Basically looking to identify if anyone goes in and manipulates the criteria field within the query ?

Using Access 2003.

Any thoughts or help are greatly appreciated.

Thanks

do you mean by clicking "Queries" and then editing a query in design view or via a form? if you mean by the first then i dont know but i would hide the database wind (the one with the tables and stuff in) on the start up . then the user can't edit the query.

jk,

The information is available in the MSysObjects and MSysQueries tables.

Of course, these are maintained by Access and you will need to have a
"Before" and "After" view to do comparisons.


SELECT MSysObjects.Id,
MSysObjects.Name,
MSysObjects.Type,
MSysQueries.Attribute,
MSysQueries.Expression
FROM MSysObjects INNER JOIN MSysQueries ON
MSysObjects.Id = MSysQueries.ObjectId
WHERE MSysObjects.Type =5 AND
MSysQueries.Attribute In (6,8);


hth,
Wayne