Dan Waters
dwaters at usinternet.com
Wed Feb 3 06:12:23 CST 2010
I did try that - but still not working. Thanks! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rusty Hammond Sent: Saturday, January 30, 2010 1:58 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Ask Again? - Updateable Query - Access vs. SQL Server Just a clutch, did you delete the linked table and relink after setting the bit fields to not allow null? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, January 29, 2010 7:11 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Ask Again? - Updateable Query - Access vs. SQL Server The tables did have primary keys. There are several bit fields, and all were set to allow nulls, with false as the default value. I changed all the fields to no allow nulls, but that did not solve the problem. Anything else? Thanks! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rusty Hammond Sent: Friday, January 29, 2010 4:40 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Ask Again? - Updateable Query - Access vs. SQL Server A couple of things to check. Do you have primary key defined in the linked table and do you have any bit fields that allow nulls? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, January 29, 2010 4:18 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Ask Again? - Updateable Query - Access vs. SQL Server I have an Access file which contains a LEFT JOIN query between two tables. If the query uses table links to an Access BE, the query is updateable - which it should be. But if the query uses ODBC table links to a SS Express database on my PC, then the query is not updateable. To compound the mystery, the same Access query using ODBC table links to a standard SQL Server database with the same tables IS updateable! Does anyone know what's up with this or how it can be fixed? Thanks! Dan -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. ********************************************************************** -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. ********************************************************************** -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com