Dante
08-04-2007, 12:16 PM
Hi All,
Some annoying sod at work has been changing queries and i've been getting into a hell of a lot of trouble due to it!
Is there any way to record changes made to queries?
I have an audit trail to record changes to the data displayed in the forms but I really need to catch this SOB before they cost me my job?
Any ideas?
Ta
Dante
RuralGuy
08-04-2007, 12:25 PM
Only release an MDE and lock out the ShiftByPass key.
Dante
08-04-2007, 12:41 PM
It was that simple, 2-3 users need access to the queries....so even though I know it's a shortlist of suspects I really need proof in order to nail this persons ass to the wall....
Anyone got any ideas?
RuralGuy
08-04-2007, 03:09 PM
Your application should be split into FrontEnd and BackEnd and each user should have their own copy of the FrontEnd. The queries are in the FrontEnd so *only* the offender will have buggered their own query.
Dante
08-04-2007, 10:37 PM
ahhhh...interesting idea, however if I did that then they might start to think that i'm on to them....
I think i'll work on a copy from now on so if there are any changes made then I know it's not me (well I know that anyway duh!)
Thanks!
RuralGuy
08-05-2007, 12:42 AM
Having more than one user in the db at one time is a formula for corruption. Any Access application that is multi-user should be split.
Split your Access database into data and application (http://www.allenbrowne.com/ser-01.html)
Splitting your Microsoft Access MDB into a front end and back end - Why? (http://www.granite.ab.ca/access/splitapp/why.htm)