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

Rusty Hammond rusty.hammond at cpiqpc.com
Sat Jan 30 13:57:47 CST 2010


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




More information about the AccessD mailing list