<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=482595119-11072003><FONT face=Arial color=#0000ff
size=2>James,</FONT></SPAN></DIV>
<DIV><SPAN class=482595119-11072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=482595119-11072003><FONT face=Arial color=#0000ff size=2>Is
this problem for particular versions of Access or SQL Server? i.e. AXP and
SS 2000.</FONT></SPAN></DIV>
<DIV><SPAN class=482595119-11072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=482595119-11072003><FONT face=Arial color=#0000ff size=2>Dan
Waters</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>James
Barash<BR><B>Sent:</B> Friday, July 11, 2003 1:34 PM<BR><B>To:</B> 'Access
Developers discussion and problem solving'<BR><B>Subject:</B> RE: [AccessD]
Access to SQL Server - no changes<BR><BR></FONT></DIV>
<DIV><SPAN class=345282019-11072003><FONT face=Arial color=#0000ff
size=2>Virginia,</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=345282019-11072003><FONT face=Arial color=#0000ff size=2>Are
there any boolean (yes/no) fields? There is a compatability problem between
Access and SQL Server dealing with boolean data since each represents true
differently. All boolean fields must have a default value and not be nullable,
otherwise you will get an error message updating
data.</FONT></SPAN></DIV>
<DIV><SPAN class=345282019-11072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=345282019-11072003><FONT face=Arial color=#0000ff size=2>Hope
that helps.</FONT></SPAN></DIV>
<DIV><SPAN class=345282019-11072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=345282019-11072003><FONT face=Arial color=#0000ff
size=2>James Barash</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of
</B>Hollis,Virginia<BR><B>Sent:</B> Friday, July 11, 2003 10:45
AM<BR><B>To:</B> 'Access Developers discussion and problem
solving'<BR><B>Subject:</B> [AccessD] Access to SQL Server - no
changes<BR><BR></FONT></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr style="MARGIN-RIGHT: 0px"
align=left><SPAN class=800250212-15052003><FONT face=Arial size=2><SPAN
class=700094214-11072003>I have an Access 2K database with tables linked to
SQL Server so I can create some custom reports. The problem is I can't
change the data in the tables from Access. Why? Is there a setting that will
allow editing of the data or will it always be locked? I receive the error
message that the data is being edited by another
user.</SPAN></FONT></SPAN></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr style="MARGIN-RIGHT: 0px"
align=left><SPAN class=800250212-15052003><FONT face=Arial size=2><SPAN
class=700094214-11072003></SPAN></FONT></SPAN> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr style="MARGIN-RIGHT: 0px"
align=left><SPAN class=800250212-15052003><FONT face=Arial size=2><SPAN
class=700094214-11072003>Virginia</SPAN></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></SPAN></BODY></HTML>