Prev: letters
Next: update tables
From: joelgeraldine on 17 Mar 2010 09:40
,c, ;;::!�

"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:
> [CreateDate]
> [CreatedBy]
> [LastUpdated]
> [UpdatedBy]
>
> 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).
>
> Regards
>
> 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
> possible/necessary.
>
> "Suddi" <Suddi(a)discussions.microsoft.com> wrote in message
> news:309A184C-962F-47B2-9E94-D04BB71C5BEC(a)microsoft.com...
>>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
>> add
>> fields to my database to store create_userid and modify_userid. Can
>> someone
>> help me with that please?
>
>
First  |  Prev  | 
Pages: 1 2
Prev: letters
Next: update tables