who changed what?

[rlambkin]

Hi

I am building a multiuser databse and i would like to monitor who makes what changes to the database, does anyone have any suggestions as to the best way to do this.

Thanks

Rob

 

[Nouba]

you could use the CurrentUser Method. For more see your help file.

 

[Pat Hartman]

You can keep track of who changed a table row by adding ChangedByUser and ChangeDateTime fields to each table. Then in the BeforeUpdate event of each form, populating these fields. There is no way to track who modified objects such as forms/reports/queries unless you install a product such as SourceSafe.

 

[rlambkin]

thanks for that will give it a try

Cheers

Rob