<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<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></SPAN></BODY></HTML>