From: joelgeraldine on 17 Mar 2010 09:40
"Jeff Boyce" <nonsense(a)nonsense.com> a �crit dans le message de groupe de
discussion : u587PLJvKHA.4752(a)TK2MSFTNGP04.phx.gbl...
> The general concept is that you'd add fields to each table for which you
> wish to keep this information.
> The fields I generally add are:
> Then I add code in each form that displays table data. That code checks
> to see if the data is a new record or is an update to an existing record,
> and updates the above fields accordingly.
> Another way might be the audit trail approach that Allen Browne describes
> (check on-line).
> Jeff Boyce
> Microsoft Access MVP
> Disclaimer: This author may have received products and services mentioned
> in this post. Mention and/or description of a product or service herein
> does not constitute endorsement thereof.
> Any code or pseudocode included in this post is offered "as is", with no
> guarantee as to suitability.
> You can thank the FTC of the USA for making this disclaimer
> "Suddi" <Suddi(a)discussions.microsoft.com> wrote in message
>>I am new to Access and have an Access 2003 database without user-level
>> security that I am planning to convert to Access 2007. I would like to
>> fields to my database to store create_userid and modify_userid. Can
>> help me with that please?