Identify any changes made to query criteria ?

[jkpats12]

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

 

[spasticus]

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.

 

[WayneRyan]

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