Track Design Changes

[strvariant]

Hi all,

I am searching for a way to track when a form/report/query is changed by
users. For instance:

1) A user opens a form/report

2) The user enters the Design mode of that form/report

3) The user makes a change

4) The user saves the change

5) The user exits the form/report

A report I have can show new objects by looking in the system tables. Is
there a system table that keeps track of design changes and by whom? Or
maybe the On_Close event can append a record from the design mode?

Thanks for the help,

strvariant

[David Schofield]

Re: Track Design Changes

On Sat, 09 Apr 2005 20:53:59 -0500, strvariant <no.email.com > wrote:
[color=blue]
>Hi all,
>
>I am searching for a way to track when a form/report/query is changed by
>users. For instance:
>
>1) A user opens a form/report
>
>2) The user enters the Design mode of that form/report
>
>3) The user makes a change
>
>4) The user saves the change
>
>5) The user exits the form/report
>
>A report I have can show new objects by looking in the system tables. Is
>there a system table that keeps track of design changes and by whom? Or
>maybe the On_Close event can append a record from the design mode?
>
>Thanks for the help,
>
>strvariant[/color]
Hi
Some would say, prevent your users altering anything!

Nothing built-in apart from the date of the most recent change to each
object. However this could be due to something trivial like sorting
A-Z or even compacting the database in some cases.
If you program this yourself you could capture when and who changed
things but how about why?

I expect someone has done something along these lines - I looked in
Google but as usual the problem is sorting out which items refer to
Access (the database), since so many articles contain the word access
in the normal sense. The usual tricks (eg adding "vba") didn't help.
Sorry,
David
PS I hope this doesn't stop anyone else answering!