[AccessD] Access to SQL Server - no changes

Dan,
I've run into the problem with Access 97/2000/XP and SS 2000. I don't
know if it applies to other versions of SQL Server.
 
James Barash

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, July 11, 2003 3:54 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Access to SQL Server - no changes


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/6b165819/attachment-0001.html>