[AccessD] Write Conflict

Hey Francisco,
   Have you checked if the table has a TimeStamp Column (I said to myself).  

When I checked and the answer was no, I quickly added it and refreshed
the Access Link, and now it works fine in both Access2000 and
Access2003.

Wierd eh?... btw thanks! 

On 9/8/05, Francisco Tapia <fhtapia at gmail.com> wrote:
> 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)
>