[AccessD] Access to SQL Server - no changes

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>


More information about the AccessD mailing list