[AccessD] Access to SQL Server - no changes

Virginia,
 
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.
 
Hope that helps.
 
James Barash

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Hollis,Virginia
Sent: Friday, July 11, 2003 10: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/84b30400/attachment-0001.html>