[AccessD] Ask Again? - Updateable Query - Access vs. SQL Server

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.
**********************************************************************




More information about the AccessD mailing list