Dan Waters
dwaters at usinternet.com
Fri Jul 11 14:54:06 CDT 2003
James, Is this problem for particular versions of Access or SQL Server? i.e. AXP and SS 2000. Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of James Barash Sent: Friday, July 11, 2003 1:34 PM To: 'Access Developers discussion and problem solving' Subject: RE: [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/b46f3992/attachment-0001.html>