Francisco Tapia
fhtapia at gmail.com
Thu Sep 8 11:06:29 CDT 2005
I have a linked table to a sql server database... there are "NO Triggers" on this table. I can insert new data without any issues. I cannot edit any data via Access at all. The OS is Windows 2003 the sql server is Sql2000 SP3. If I open up the table via EM I can edit the record w/o any issues, if I update the table using QA it updates again no problems, the problem w/ the writeconflict is only when I use an Access 2000 or Access 2003 Linked table. any clues? -- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More... (Gmail Invites available)