Rusty Hammond
rusty.hammond at cpiqpc.com
Fri Jan 29 16:40:27 CST 2010
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. **********************************************************************