[AccessD] Access to SQL Server - no changes

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.
Jim Hale

-----Original Message-----
From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com]
Sent: Friday, July 11, 2003 9:45 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Access to SQL Server - no changes


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.
 
Virginia

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030711/2b57ddc1/attachment-0001.html>