<!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=773411820-11072003><FONT face=Arial color=#0000ff
size=2>Dan,</FONT></SPAN></DIV>
<DIV><SPAN class=773411820-11072003><FONT face=Arial color=#0000ff size=2>I've
run into the problem with Access 97/2000/XP and SS 2000. I don't know if it
applies to other versions of SQL Server.</FONT></SPAN></DIV>
<DIV><SPAN class=773411820-11072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=773411820-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>Dan
Waters<BR><B>Sent:</B> Friday, July 11, 2003 3:54 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=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></BLOCKQUOTE></SPAN></BODY></HTML>