SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 08:15 PM
| ||||
| ||||
 User names 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?      |
|
02-27-2008, 08:16 PM
| ||||
| ||||
| Re: User names 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/downl...s/default.aspx -Sue On Thu, 19 Aug 2004 08:31:16 -0700, "Phil Burns" <anonymous@discussions.microsoft.com> wrote: >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? |
Linear Mode
