<!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.2719.2200" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=596261415-11072003><FONT color=#0000ff
size=2>Virginia,</FONT></SPAN></DIV>
<DIV><SPAN class=596261415-11072003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=596261415-11072003><FONT color=#0000ff size=2>How do you have
the connections set up? You may have read-only connections, or read-only
cursors, or several other things that restrict the data to read-only. The
error message seems unusual unless either you or the other user is using table
locks instead of record locks.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Texas Education
Agency</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>1701 N. Congress
Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin, TX
78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Hollis,Virginia
[mailto:HollisVJ@pgdp.usec.com] <BR><B>Sent:</B> Friday 2003 Jul 11
09:45<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></SPAN></BODY></HTML>