[AccessD] Access to SQL Server - no changes

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

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 

-----Original Message-----
From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com] 
Sent: Friday 2003 Jul 11 09:45
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/f4e6257a/attachment-0001.html>