<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1126" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=305534518-11072003><FONT face=Arial color=#0000ff size=2>I have
had somewhat similar problems with an ODBC connection to AS400 tables. The fix
required using a system DSN rather than a file DSN. Just a
thought.</FONT></SPAN></DIV>
<DIV><SPAN class=305534518-11072003><FONT face=Arial color=#0000ff size=2>Jim
Hale</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader 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, July 11, 2003 9: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>