[AccessD] Write Conflict

Doh!...
Your google-fu is much better than mine ;)

On 9/8/05, Roger.Carlson at spectrum-health.org <
Roger.Carlson at spectrum-health.org> wrote:
> 
> The underlying issue may be that you have a Null Bit field. See this:
> http://support.microsoft.com/kb/280730/EN-US/
> 
> Adding a timestamp is one of the solutions. Another is to create a default
> value for the field.
> 
> --Roger Carlson
> http://www.rogersaccesslibrary.com
> 
> 
> -----Original Message-----
> From: Microsoft Access Database Discussion List
> [mailto:ACCESS-L at PEACH.EASE.LSOFT.COM]On Behalf Of Francisco Tapia
> Sent: Thursday, September 08, 2005 12:15 PM
> To: ACCESS-L at PEACH.EASE.LSOFT.COM
> Subject: Re: 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)
> >
> 
> --------------------------------------------------------------------------
> The ACCESS-L list is hosted on a Windows(R) 2000 Server running L-Soft
> international's LISTSERV(R) software. For subscription/signoff info
> and archives, see http://peach.ease.lsoft.com/archives/access-l.html .
> COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=ACCESS-L
> 



-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...