How do you get SQL server to keep a note of amendments to
records in tables? We use MS Access 2000 & 2003 and SQL
2000, XP Pro / NT4 and Win 2003 server.
Also, why do I always have to re-link all the tables on
the NT4 workstations on an .mdb which works fine on all XP
w/s?

One option is to create triggers on the tables for which you
want to track changes. You can find more information on
triggers in SQL Server Books Online
In terms of your relinking the tables in Access, maybe it's
an MDAC version difference. You can use Component Checker to
verify, compare the MDAC version on the different
workstations. You can download the component checker from:
http://msdn.microsoft.com/data/downloads/tools/default.aspx

-Sue

On Thu, 19 Aug 2004 08:31:16 -0700, "Phil Burns"
[quoted text, click to view]