Audit 3 fields in one table

Hello,
I am unfamiliar with SQL Server 2005 but want to learn more.
I have an application with a MS Access 2003 Front end and a 2005 SQL
Server backend.
I have a table called HandoverClinicalChanges, there are 3 main fields
which are updated by Doctors - usually by adding to the end of the
previous entry, sometimes by deleting the previous entry and adding
their own.

I want to be able to capture the changes and additionsthey record to
these fields in a table (? audit table).
Is there an easy way do this in SQL SERVER 2005 or should I do it in
ACCESS FE?
Thank you for any help and advice.
Regards
Kev

.

Relevant Pages

  • Re: Same query - different execution plans??
    ... Next, we ran the query from QA, it added an entry to syscacheobjects. ... Books Online does not specify which bit ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: How would you... (binary info in a table)
    ... I've got the code to parse the ... multiple "entries" stored in a single binary field. ... this particular SQL entry. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Transaction Tracing
    ... in VB with SQL server 7 as back end. ... entry in a particular filed in a table through SQL Enterprise Manager. ... I know the primary key ... my qustion is whether it is possible to trace the timestamp of an entry ...
    (microsoft.public.sqlserver.security)
  • Re: Select statement help
    ... existence of an known entry and then display that entry and the table ... Select * from everything_in(select tablename from tableA) where entry ... Sounds like you have a bad database design. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Interesting fix to SQL connection failure for SPS
    ... WSS sites work but SPS does not ... "Microsoft OLE DB Provider for SQL Server" Description: ... the following DNS cache entry for our SQL server instance: ... sample hosts file modification: ...
    (microsoft.public.sharepoint.portalserver)